Importing Excel Data

  • Thread starter Thread starter HotRod
  • Start date Start date
H

HotRod

I have a large 60 MB excel file that has around 45 columns A to AS all of
the columns are 65000 rows long and contain the same data, I need to import
this data into a single field in access. Any ideas? How can I import these?
 
I'm presuming you mean you want to import the data into a single access TABLE
(as I can't imagine why you'd want it in one field).

A good starting point would be to create a new access database then
file / get external data / import /
navigate to your excel file, choose the worksheet, then indicate whether or
not the first row contains column headings, and tweak the options to suit
until you get to the 'finish' button.

Access shouldn't have any problems with either 45 different fields (aka
columns) or 65000 records (aka rows). The most difficult bit is getting your
field names and properties correct, but it's probably easiest just to have a
go and then see what you come out with.
 
If you really want it all into a single Access field then I suggest a two
step process.
Import like it is - in 45 fields and then concatenate it in a memo field.
Weird why you want it all in one field!
 
OK I know this sounds weird but every single excel columns contains postal
codes

Column A = 65000 Postal Codes
Column B = 65000 Postal Codes
Column C = 65000 Postal Codes etc. etc.

since the original creator couldn't put these into a single column because
of excel restrictions, Now I want to put all of the postal codes into a
"SINGLE" field in access.
 
Back
Top