Copy and Paste into Access 2007

[mschmucker]

I have a handheld that downloads data into a CSV file. I was copying the data into an access database. Certain fields and have text and/or numbers. While I was using Office XP this worked great after switching to office 2007 when I copy fields that have text in one row and numbers in the next, only the cells with numbers copy, the text just copies in blank fields. Any ideas or a fix for this?

Thanks

 

[PaulO]

I have a handheld that downloads data into a CSV file. I was copying the data into an access database. Certain fields and have text and/or numbers. While I was using Office XP this worked great after switching to office 2007 when I copy fields that have text in one row and numbers in the next, only the cells with numbers copy, the text just copies in blank fields. Any ideas or a fix for this?

Thanks

Table fields don't like mixed data. So, I reckon you've probably got that particular field set for Numbers, hence text cannot be imported.

If you changed the field to Text then, probably, all the data will be accepted (numbers will look like numbers but be stored as text).

The proper answer is for you to download values and text into separate fields and then pull them into your Access table.