input into access - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

input into access

input into access# Database - 数据库

l*k2003-06-27 07:06

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*a2003-06-27 07:06

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*k2003-06-27 07:06

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*r2003-06-27 07:06

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*s2003-06-27 07:06

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.