Import Overwrite Data in Table

[Brent E]

I have a question.

When you import data on a frequent basis from Excel to Access and into an
already existing table? Does the import automatially overwrite existing
records, or does it only append new records?

Thanks.

 

[Maurice]

Access will overwrite but will ask you for confirmation first.

hth

 

[Brent E]

Great. Thanks.

Also, when you Export a spreadsheet to Excel. Is there a way to use VBA to
force an overwrite of the file without prompting for permission?

 

[Maurice]

Bob,

I have to disagree. After seeing your post i decided to try it again with a
simple excelbook. btw i tried it on a vista machine with off. 2007.

I imported a simple excelsheet with a row of text like "option 1" - through
"option 42". I imported this into Access which created a table called
"Sheet1". After that I altered the data in the Excel worksheet, saved it and
imported it into the existing sheet1 table. Access will ask you if you want
to overwrite the exisisting table. I tried with keys different options but it
will ask you if you want to overwrite.