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: runuphillracing@yahoo.com
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (1) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar