PipMic
asked on
Excel tables to MSAccess
Hi all,
Grateful if anyone could show me how to convert the data in an Excel workbook with has three worksheets into an MSAccess table from MSAccess.
Preferably I would like to know if it can be done using vba.
I am attaching my sample excel file so it can be seen.
Thanks
tablesforAccess.xls
Grateful if anyone could show me how to convert the data in an Excel workbook with has three worksheets into an MSAccess table from MSAccess.
Preferably I would like to know if it can be done using vba.
I am attaching my sample excel file so it can be seen.
Thanks
tablesforAccess.xls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Tried this one line but no luck:
DoCmd.TransferSpreadsheet acImport, 8, "table1", "c:\1\tablesforAccess.xls" , True, "sheet1!"
Compile error
Invalid outside procedure
DoCmd.TransferSpreadsheet acImport, 8, "table1", "c:\1\tablesforAccess.xls"
Compile error
Invalid outside procedure
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
very good
ASKER