linking xls files from Access - 未名空间MITBBS历史存档

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

Redian新闻

>未名空间

>Database - 数据库

linking xls files from Access

linking xls files from Access# Database - 数据库

l*k2002-09-05 07:09

1 楼

I am setting up an access db by linking multiple xls files to
access table. However, some xls files linked fine, while some
having trouble to show numbers, all number files appears as "#Num!"
in access..
all my files are perl generated .csv files, I transformed them to
xls format... all files are done the same way... I don't know why
some works while some others won't...
Thanks for your help.

h*e2002-09-05 07:09

2 楼

it is a normal bug? of excel
when u convert .csv to .xls, excel will treat any number data or number
related data (say, "124E30", excel 自作主张的认为这是科学技术法 //DD)
as number type, so when the "123E30" goto your access table, it is out
of range, which will be displayed as #num!
well, for me, i'll write a small program to process the csv2xls myself
set the FieldFormat property (or sth. like this) to "Text", instead of
the default value "General", expecially for those string fields. then
everything should

【在 l*****k 的大作中提到】

: I am setting up an access db by linking multiple xls files to
: access table. However, some xls files linked fine, while some
: having trouble to show numbers, all number files appears as "#Num!"
: in access..
: all my files are perl generated .csv files, I transformed them to
: xls format... all files are done the same way... I don't know why
: some works while some others won't...
: Thanks for your help.

l*k2002-09-05 07:09

3 楼

thanks, man! I have been receiving contradictory information... it seems to be
any **E-** is ok, once I set the all to General... and I just realized
linking from .csv is probably a better idea.
when a column has mixed data, excel gets more confused.... MS just is a
little bit too smart.

【在 h****e 的大作中提到】

: it is a normal bug? of excel
: when u convert .csv to .xls, excel will treat any number data or number
: related data (say, "124E30", excel 自作主张的认为这是科学技术法 //DD)
: as number type, so when the "123E30" goto your access table, it is out
: of range, which will be displayed as #num!
: well, for me, i'll write a small program to process the csv2xls myself
: set the FieldFormat property (or sth. like this) to "Text", instead of
: the default value "General", expecially for those string fields. then
: everything should