Excel Range to Access Table
Hullo,
I'm wondering if someone could enlighten a newcomer to VB. In Excel VB, I would like to do the equivalent of copying a range of cells (say, "A1:D10") and creating that range as a table in an Access database. It can be done easily by having both applications open and manually doing the copy and pasting, so I'm sure there's a way to do it in code. Any advice appreciated. Tokash |
Excel Range to Access Table
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. You can also download the demonstration file called "excelsql.zip". The code is open and commented. -- Regards Andy Wiggins www.BygSoftware.com Home of "The Excel Auditor" and "Byg Tools for VBA" "Tokash" wrote in message ... Hullo, I'm wondering if someone could enlighten a newcomer to VB. In Excel VB, I would like to do the equivalent of copying a range of cells (say, "A1:D10") and creating that range as a table in an Access database. It can be done easily by having both applications open and manually doing the copy and pasting, so I'm sure there's a way to do it in code. Any advice appreciated. Tokash |
All times are GMT +1. The time now is 10:25 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com