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

Populating Access fields with information from an Excel spreadsheet

P: n/a
I have an Excel spreadsheet with two fields of data, part number and
product code (hundreds of lines of data).
The same fields of data are in a database, however the product code
fields are empty. I need to somehow have Access look at the
spreadsheet and if the part number in the spreadsheet matches the part
number in Access, it will populate the Access product code field with
the corresponding product code data that resides in the spreadsheet.
Hope this makes sense. Can someone get me jump-started in the right
direction on how to go about doing this?
Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.