What happens if you select the column in Excel and change its type to Text, then save the file under a temporary name? Maybe that would then import OK into Access.
Dave W
----- Original Message -----Sent: Wednesday, April 22, 2015 6:42 PMSubject: [MS_AccessPros] Problem copying/importing from Excel
I'm missing data in one of the fields when copied from Excel into an existing table. The field, AcctNo, is a text field. That column in Excel contains both numbers and alphanumeric data. When I bring the data over, whether I copy and paste-append or import, only the all-numeric AcctNos come across and all of the alphanumeric fields are blank. It only works when I import to a new table, then write a query to bring it into the table I want. I don't want to do that because this is something that'll repeat every month.
Any ideas why this is happening, how to fix it?
Adam
__._,_.___
Posted by: "Dave W" <davewi11@yahoo.co.uk>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (8) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar