Adam
That might be the only way you can get it to work. Access looks at the first few rows to determine the data type. If it decides it is numeric it will error out on the alpha data.
---In MS_Access_Professionals@yahoogroups.com, <runuphillracing@yahoo.com> wrote :
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: wrmosca@comcast.net
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (3) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar