By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,192 Members | 1,253 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,192 IT Pros & Developers. It's quick & easy.

Excel Spreadsheet to Access Question

P: n/a
Hi All, hope someone can lead me in the right direction. I am in new
territory and am unsure what to do after importing an Excel
Spreadsheet into my database.

1. The same spreadsheet with new information will periodically be
imported into the database into tblImport.
2. I've created a query to so as to separate out the three fields and
criteria that I need to be incorporated into the database named
qryImport.

I need to:

1. Save the queried data from tblImport into an existing table named
tblExisting (created just for this information) and delete all data in
tblImport so that it will be blank for the next time a spreadsheet
needs to be imported.

2. Since the row headings of the Spreadsheet differ from the table
names of tblExisting, how do I deal with this issue when the queried
data is saved in this table.

Thank you in advance for any help in this matter.

Maurita Searcy
Feb 6 '08 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.