Copy paste from CSV to Access 2010

[mschmucker]

I have a handheld that downloads a CSV file which I copy and paste into an Access database. I was using XP and moved to 2010, with xp this worked great. In 2010 some fields that text and/or numbers will only copy the numbers and the field that have text will just have a blank in access. Is there a fix for this?

Thanks

[TheShabz]

Have you tried Importing it instead of copy/paste? The Import tool gives you much more control over datatypes.

Generally, if I'm using copy/paste, I insert a dummy line of text right under the headings. Access decides datatype by the first field. This will force everything in as text, which won't lead to omission or truncation. I can then go into the table itself and change the datatypes of the fields to whatever is necessary.