Importing Spreadsheets into table in Access 2013

This post has been de-listed

It is no longer included in search results and normal feeds (front page, hot posts, subreddit posts, etc). It remains visible only via the author's post history.

Post Body

So I have a user with an old Access DB that they used in Access 2003 where in several places they used the Import function, which I have since learned appears deprecated. It appears that the ImportAttachExcel seems like it should serve the same function, but I am running into the problem that it wants to replace the destination table whereas in Access 2003 it would simply append the data. If I have additional columns in the destination table that for any reason the source spreadsheet lacks I will lose those fields.

Am I missing something about how to simply append rather than replace or is there a better way to update this legacy Access DB?

Author

Account Strength

90%

Account Age

9 years

Verified Email

Yes

Verified Flair

Total Karma

4,633

Link Karma

Comment Karma

4,552

Profile updated: 6 days ago

Posts updated: 6 months ago

awkwardsysadmin

Subreddit

r/MSAccess

Post Details

We try to extract some basic information from the post title. This is not always successful or accurate, please use your best judgement and compare these values to the post title and body for confirmation.

Posted: 8 years ago
Reddit URL: View post on reddit.com
External URL: reddit.com/r/MSAccess/co...