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

Automated Data import from an excel form!!

P: n/a

I am working for client, they need to automate data entry to the access
DB, by importing it from an excel sheet into 4 diferent tables is there
any good solution to so?

Many Thanks

Kind Regards

Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies

P: n/a
easiest way is to do something like this:
1. link to the spreadsheet (File, Get External Data, Link Tables...)
2. create an append query selects the fields you want from your
attached Excel file and writes it to the correct fields in your Access

do that for each set of fields/tables and you're all set.

Nov 13 '05 #2

P: n/a
Many Thanks
It worked The way described

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.