Access scans first 25 rows of a file to determine data type

[BulbFresh]

Hi,

I'm using Access 2000 and importing .csv files to a table. This works very well apart from one column which sometimes will be a short note (text < 255 characters) and sometimes a long explaination (memo > 255 characters).

My problem is that for the first 25 rows of the .csv file the entries in this field are quite short therefore on import Access thinks it's a short text field rather than the longer memo data type. Needless to say the longer values just get cut off and data is lost.

Any ideas?

Thanks,

Chris

[Denburt]

Set yourself up a schema and roll with it.
http://support.microsoft.com/kb/210001

If you have any questions on implementing this just let us know.

[BulbFresh]

Cool thanks, i'll give it a go.

[Denburt]

Oh and there is another way also, if you use the wizard to import 1 of the items when the wizard opens you click advanced and there is an option to save that import specification (it will be stored somewhere in the database sys tables). Once prompted for a name you should be able to call it from code as you would an external schema file.

While in the VBA window you can go to help and type in "TransferText Action" then you can place the name of your import spec or schema in the "Specification Name" location and you should be fine.