importing data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a spreadsheet that has the following coloums.
Symbol, Company Name, Exch, High, Last, Change, Volume, Rel Str, and links
I would like to import that spreadsheet into a table in access.
table is setup like this
ID Autonumber PK
Date Date/time
Symbol text
Company name text
Exch text
High number
last number
change number
volume
but when I try to import it I get "An error occured trying to import the
file blah.xls. the file was not imported"
what am I doing wrong. I should mention that I will import this file once a
day.

thanks,
RogueIT
 
I have a similar problem this is what I found out:
The column heading in excel must match the name of the field in the Access
table. the order of the columns must match the order o fthe fields. For
example:

Excel column Access field name
Company Company
City City
State State

but the following may not work:
Excel column Access field name
Company Company
State City
City State

You may better off if you just link the worksheet to the your access file
that way you don't have to "import" once a day. As the Excel data is updated
the data in the table in access is updated
 
Back
Top