Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Access Table into Excel using VB | Excel Discussion (Misc queries) | |||
Excel data range to access | Links and Linking in Excel | |||
Import Access Table into Excel | Excel Worksheet Functions | |||
excel - access query - date range | Excel Discussion (Misc queries) | |||
Data from Excel to Access Table | Excel Discussion (Misc queries) |