Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VBA data export
Help!
How can I transfer data from an Excel Spreadsheet to an Access database using Excel VBA. Many thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VBA data export
Robin,
You can do it the other way and link your Access DB to the Excel file. NickHK "Robin Jootun" wrote in message ... Help! How can I transfer data from an Excel Spreadsheet to an Access database using Excel VBA. Many thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VBA data export
Check out Mr. Erlandsen's site for sample code:
http://www.erlandsendata.no/english/vba/adodao/ -- Regards, Tom Ogilvy "Robin Jootun" wrote in message ... Help! How can I transfer data from an Excel Spreadsheet to an Access database using Excel VBA. Many thanks |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VBA data export
This might be a help for getting data to and from Excel and Access: It
includes examples of using variables in SQL queries. http://www.bygsoftware.com/examples/sql.html Or you can get there from the "Excel with Access Databases" section on page: http://www.bygsoftware.com/examples/examples.htm It demonstrates how to use SQL in Excel's VBA to: * create a database, * create a table and add data to it, * select data from a table, * delete a table, * delete a database. DAO and ADO files available. You can also download the demonstration file called "excelsql.zip". The code is open and commented. -- Regards Andy Wiggins www.BygSoftware.com Home of "Save and BackUp", "The Excel Auditor" and "Byg Tools for VBA" "Robin Jootun" wrote in message ... Help! How can I transfer data from an Excel Spreadsheet to an Access database using Excel VBA. Many thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
export of data from SAP to MS-Excel 2007 | Excel Discussion (Misc queries) | |||
Data Export from Access to Excel | Excel Discussion (Misc queries) | |||
Not able to export data from IE6,7 to MS Excel | Excel Discussion (Misc queries) | |||
Data export from Crystal to Excel | Excel Discussion (Misc queries) | |||
export data to Excel?? | Excel Discussion (Misc queries) |