Importing from Excel

G

Guest

I have an excel spredsheet that I use to import data to an access table. I
cannot use linking since I want to add additional fields to the table that do
not exist in the spreadsheet; and I cannot change the fields in the
spreadsheet. How can I update the table from a spreadsheet that changes
daily without creating duplicate records in the table. If I select index,
duplicates ok, it creates mutliple duplicate records. If I select no
duplicates, it will not update the existing records.
 
J

John Nurick

Hi John,

Use a linked table, and set up another table with the additional fields,
with a 1:1 relationship between them.
 
L

Long Live Aaron Kempf

you should be using SQL Server and DTS or SSIS

I mean-- Accecss it not an ETL tool; don't try to re-invent the wheel
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Importing unique records from excel into access 2
Import excel dat to update and add new records 1
Indexed 'error' when changing index in table 2
How do i update Access Table using data from Excel spreadsheet 3
Access import from Excel - Append & Update simultaneously 1
Imported spreadsheet data from Excel to Access 1
Checking records before importing 2

Top