Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel to Access
I have created a macro in an Excel workbook to do various things with a web query, then export one sheet of the workbook as a txt file. I then get the macro to open Access. What I am wanting to do is:- I want my macro to, not only open Access, but to open a specific Access Database and if possible, run a macro within that database to import the data that I have exported from Excel. Any ideas? Thanks |
#2
|
|||
|
|||
Why wouldn't you just use ADO within VBA to run an insert query, inserting
from the Excel sheet into the Access database? That way you don't ever have to 'open' Access. I haven't done that via code in several years, and it'd take me a while to go through archived files to find a sample. I'm sure some of the MVPs here can jot off some samples lickety split, though. "Keith" wrote: I have created a macro in an Excel workbook to do various things with a web query, then export one sheet of the workbook as a txt file. I then get the macro to open Access. What I am wanting to do is:- I want my macro to, not only open Access, but to open a specific Access Database and if possible, run a macro within that database to import the data that I have exported from Excel. Any ideas? Thanks |
#3
|
|||
|
|||
See if this site helps you out:
http://www.exceltip.com/exceltips.ph...ategory&ID=213 -- Regards, Ron |
#4
|
|||
|
|||
See thread in Misc
-- Regards Ron de Bruin http://www.rondebruin.nl "Keith" wrote in message k... I have created a macro in an Excel workbook to do various things with a web query, then export one sheet of the workbook as a txt file. I then get the macro to open Access. What I am wanting to do is:- I want my macro to, not only open Access, but to open a specific Access Database and if possible, run a macro within that database to import the data that I have exported from Excel. Any ideas? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
my data truncates when ported from access to excel | Excel Worksheet Functions | |||
Microsoft Access Report into Excel Spreadsheet | Excel Discussion (Misc queries) | |||
How do I get an Access form in Excel to Expand the Data | Excel Discussion (Misc queries) | |||
Linking Excel to Access. | Excel Discussion (Misc queries) | |||
Managing an Access Database from Excel | Excel Discussion (Misc queries) |