Dear All, I have an excel file (.xls) with data in the first Sheet that is named "Customers". I also have an Access.mdb database that contains a table called " CustomerDetails". I would like to transfer the data from the excel sheet into the Access database using VB6 code. How can I do that? Thanks in advance,
-
1pay a programmer to craft such code???Mitch Wheat– Mitch Wheat2010-10-05 16:08:31 +00:00Commented Oct 5, 2010 at 16:08
-
Thanks Mitch Wheat! I figured it out myself :)guest1– guest12010-10-05 18:42:30 +00:00Commented Oct 5, 2010 at 18:42
Add a comment
|
3 Answers
Can you use Access to import the worksheet from Excel?
If not, and you need to do it in VB, you'll need to either open the Excel file in VB or export from Excel to a csv format and open that, then write the data to an existing Access table.
Comments
this is quite simple to do, just place the below code in a module in Access and this will import it for you automatically. If you need the code to run you can place it in the form_open or something similar. You could even start it up with a batch file.
Function import()
basedir = "INSERT YOUR SPREADSHEET HERE"
DoCmd.TransferSpreadsheet _
acImport, _
acSpreadsheetTypeExcel9, _
"TABLE NAME HERE", _
basedir, _
False
End Function
