[RESOLVED] Importing excel data into project database

[zendog1960]

Is there a routine that will allow me to import data from an excel spreadsheet into a database within my project? I only need to do this to populate the the database I have created in my project.

While the project was being developed I used junk test data for testing and debugging but now I wan to populate the database with the actual records.

Here is the skinny:

In the project database I have the following fields:
ItemID - Primary key
SamCode
FullName - this is one of the fields that need to be populated from excel
UPCnumber - another field needed to be populated from excel
OnHand
ReorderLevel
OrderQty

From Excel here is what I have:
Column B contains the Full Name Data where B1 in a column header
Column C contains the UPC Numbers needed where C1 is a column header

As stated this is a one time deal and not something I need to run as part of the application. If any of you coding gurus could help me with this I would be extremely appreciative!

Thanks so much.