LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Keith
 
Posts: n/a
Default 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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
my data truncates when ported from access to excel Confused access user Excel Worksheet Functions 4 May 13th 05 03:50 AM
Microsoft Access Report into Excel Spreadsheet zeebyrd Excel Discussion (Misc queries) 1 February 27th 05 12:36 AM
How do I get an Access form in Excel to Expand the Data RogerN Excel Discussion (Misc queries) 0 February 25th 05 06:04 PM
Linking Excel to Access. Richard Excel Discussion (Misc queries) 3 February 15th 05 09:55 PM
Managing an Access Database from Excel Kostis Vezeridis Excel Discussion (Misc queries) 2 February 11th 05 05:21 PM


All times are GMT +1. The time now is 03:06 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"