By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,509 Members | 2,185 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,509 IT Pros & Developers. It's quick & easy.

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

P: 10
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
Mar 5 '08 #1
Share this Question
Share on Google+
3 Replies


Denburt
Expert 100+
P: 1,356
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.
Mar 5 '08 #2

P: 10
Cool thanks, i'll give it a go.
Mar 5 '08 #3

Denburt
Expert 100+
P: 1,356
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.
Mar 5 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.