Export data from Excel to Access Table (ADO) using VBA

[excel_vba_prog]

hi, I am new to excel vba programming, I used your code to export data from excel to access 2007, works perfectly, except for one problem. if the excel column has more than 255 characters in the rows, then I am getting error "too much data", since the default property for access columns is 'text', how to modify your code to be able to change property to 'memo' if length of data is more than 255? Thanks!

[Manfred]

Hello, you can find information about your problem here Insert, change, or delete a Memo field - Access, hope help you.