Import data from Excel

[Boon]

Hello,

I have a big excel file that contains 80 columns and 35000 rows. I have
about 20 of this files. I would like to import all of them into Access. What
is the best way to do this?

My thinking is to write VBA to import it and link to a form that the user
can change the name of the file? I have written a VBA form to import data
from text file and using import specification. Is it the same with import
Excel?

Thanks,
Boon

 

[Jeanette Cunningham]

Hi Boon,
it is similar.
Use TransferSpreadsheet instead of transfer text.
A2003 does not allow import specification to be used with transfer
spreadsheet.

A2007 does allow more options when importing from excel, but I haven't tried
that yet.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[Lord Kelvan]

just as an important note when importing or linking from excel access
reads the first 7 rows to determine what the data type is this may
break the import a classic example i have to deal with is phone
numbers

some people enter

5555555
some enter
555 5555
some enter
555 55 555
or
(55)555 5555

access will read this as text so the phone number
5555555
will not import and display error#

just be weary of your data

Regards
Kelvan