l*****k 发帖数: 587 | 1 I find importing to access extremely annoying, since it never
tell what the problem is except for there is an error...
is there a way to paste an excel column(s) to an access column(s)
thanks | a*****a 发帖数: 438 | 2 import external data
【在 l*****k 的大作中提到】 : I find importing to access extremely annoying, since it never : tell what the problem is except for there is an error... : is there a way to paste an excel column(s) to an access column(s) : thanks
| l*****k 发帖数: 587 | 3 that's what I did, it only says there is some error occurred and import
failed... I was trying to import to an existing table though.
how do I import only a column ?
I don't know if there are better ways, learning VBA is too much
for me to handle, since it not worth the time for the project.
【在 a*****a 的大作中提到】 : import external data
| M*****r 发帖数: 1536 | 4
I also met similar problems. In my case, the main problem is data format.
We have date type, character, number, and sth like 15a.
What we did finally is in Excel, set ALL columns to be Text format, then
save as text file, import into Access.
【在 l*****k 的大作中提到】 : I find importing to access extremely annoying, since it never : tell what the problem is except for there is an error... : is there a way to paste an excel column(s) to an access column(s) : thanks
| e*********s 发帖数: 200 | 5
If you have SQL server, you can use DTS to import Excel data into Access and
specify the data format for each column :)
【在 M*****r 的大作中提到】 : : I also met similar problems. In my case, the main problem is data format. : We have date type, character, number, and sth like 15a. : What we did finally is in Excel, set ALL columns to be Text format, then : save as text file, import into Access.
|
|