[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.

[Help321]

What's your database?

What's your ItemID field, a sequential number?

You could probably just copy and paste the data straight into the DB fields. But SQL Server, SQL Express have DTS or equivalent. Or if you have Access you can use the Import function within that.

As it's a one time deal, there's little point coding it as within a few mouse clicks you can import your data.