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

Automated Data import from an excel form!!

P: n/a
Hi5
Hi,

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
table

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

Nov 13 '05 #2

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

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.