Import Excel to Access Question

[Maurita]

Hi, I need some help on importing data from Excel to Access. The
Excel spreadsheet has the same columns, i.e. Date, Description. The
problem I am having is that each spreadsheet that will be imported
will have some of the same engine numbers, and some new engine number
information in the spreadsheet, which is first entered into the DB
table. Can Access import different info into the spreadsheet each
time if it's in the same table? For example, the table has info Date,
Description, A, B, C. The spreadsheet has columns Date, Description,
A, E, S.

Also, when importing info from an Excel spreadsheet into Access, will
the blank fields in the spreadsheet come over as 0 or blank?

Thank you so very much for all your help.

Maurita Searcy

 

[Pieter Wijnen]

Not as such

you need to Import the excel File into an ImportTable
Insert into & update your "real" table through queries (and/or code)
Empty Excel Cells are imported as Null (blank)

HTH

Pieter

 

[Maurita]

Not as such

you need to Import the excel File into an ImportTable
Insert into & update your "real" table through queries (and/or code)
Empty Excel Cells are imported as Null (blank)

HTH

Pieter









- Show quoted text -

Thank you Pieter for your response. I have created an import table
but am having trouble getting the info from the spreadsheet imported
into it. I have checked the spreadsheet fields against the database
fields and they are the same type, but I keep getting an error and the
data is not imported. Do you have any ideas, I am using Access 2002.

Thank you.

Maurita

 

[Pieter Wijnen]

I've also had a lot of problems Importing from Excel over the years
I Usually end up recreating (Import into new table) Each Time
Therefore I Usually rely on Text Files or XML for Imports when possible

Pieter

 

[Maurita]

I've also had a lot of problems Importing from Excel over the years
I Usually end up recreating (Import into new table) Each Time
Therefore I Usually rely on Text Files or XML for Imports when possible

Pieter









- Show quoted text -

Thank you so very much Pieter for your help. I couldn't understand
why everything I had done hadn't worked. I'm glad I'm not the only
person who has had trouble with getting importing accomplished.

 

[banty]

I've also had a lot of problems Importing from Excel over the years
I Usually end up recreating (Import into new table) Each Time
Therefore I Usually rely on Text Files or XML for Imports when possible

Pieter









- Show quoted text -

Thank you so very much Pieter for your help. I couldn't understand
why everything I had done hadn't worked. I'm glad I'm not the only
person who has had trouble with getting importing accomplished.