extract field into Database

[wilbasket23]

is there any way i can do it in a programming way.

also if there are many excel form, can i grap some field in each form and put into the database

[doctorgonzo]

Yes, there is a way. How familiar are you with VBA script?

What this will entail is code that is separated into three parts: 1) grab the data from the Excel file, 2) put the data into the form you want, 3) insert the data into an Access database.

The first section will probably just involve grabbing the data from the right cells in the spreadsheet. The second section is whatever you want it to be. The third section involves using recordset objects in ADO or DAO to append the data to tables in Access.

[wilbasket23]

can you show me some coding example. thank you

[doctorgonzo]

Please don't double-post. There is no need to start a new thread on this subject.

Here is a snippet: http://dbforums.com/arch/243/2003/8/881105

You might want to check out this website: http://www.exceltip.com/

Honestly, though, without knowing what you want to do, code pieces aren't helpful. As I said before, this can be broken up into three relatively easy steps. Check Excel's VBA help system for information on accessing data in a cell or manipulating data types if you don't know how to do these things.