Sql Insert statement

I have a access database that ihas multiple tables in it . One table " tblChemistry" needs data inserted from a dbf file called tblData. The table tblData  resides  on a mapped drice z:...... I would like to be able to insert this data without using the import function in access. I cant figure out the sqlinsert stamant

Thanks guys
stephenz43Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

samtran0331Commented:
all you need is the sql? is the dbf file linked into the access db then?
samtran0331Commented:
if tblChemistry and tblData have the exact same number of fields and the fields match, you can:
INSERT INTO tblChemistry  SELECT * FROM tblData

if you need to do some "mapping" of the fields:
INSERT INTO tblChemistry (field1, field2, field3) SELECT field2, field4, field7 FROM tblData
stephenz43Author Commented:
the dbf file is not linked to the access mdb..... Its just a standalone file that need to be inserted into an file. all the field names match and the number of fields are the same
samtran0331Commented:
Instead of using "Import", I would try:
1. Link the dbf file, it will show up in your "Tables" section as a table.
2. Rename it to: tblData
3. Create a new query with:
INSERT INTO tblChemistry  SELECT * FROM tblData

You should then be able to double-click the query to import the dbf to the tblChemistry.

For that matter, once the dbf file is linked as a table in Access, you can use it from within access and make relationships or call it from code just like you would a "real" table in the database.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic.NET

From novice to tech pro — start learning today.