Automation of Import/Export function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

1. What tool and script do I use to automate the importing of data from
various Excel spreadsheets into previously set up Access Tables?

2. What tool and script do I use to automate the Exporting of data from
various Microsoft program sources [Outlook Contacts, etc.] into previously
set up Excel spreadsheets?

Grateful for your help,

Steve Walsh
MarketCounsel.org
866-261-3886
 
Check out TransferSpreadsheet in Help file regarding importing EXCEL data
into ACCESS.
 
Thanks Ken!

For question number 2, will this code work...even for Access 2003 & Business
Contact Manager: How to programmatically export Outlook items to Access:
http://support.microsoft.com/kb/290792/

Steve
(e-mail address removed)

Ken Snell said:
Check out TransferSpreadsheet in Help file regarding importing EXCEL data
into ACCESS.

--

Ken Snell
<MS ACCESS MVP>

Steve said:
1. What tool and script do I use to automate the importing of data from
various Excel spreadsheets into previously set up Access Tables?

2. What tool and script do I use to automate the Exporting of data from
various Microsoft program sources [Outlook Contacts, etc.] into previously
set up Excel spreadsheets?

Grateful for your help,

Steve Walsh
MarketCounsel.org
866-261-3886
Click to expand...
Click to expand...
 
That looks like it should be ok. I personally don't use Outlook so I've
never used Automation with it.

--

Ken Snell
<MS ACCESS MVP>

Steve said:
Thanks Ken!

For question number 2, will this code work...even for Access 2003 &
Business
Contact Manager: How to programmatically export Outlook items to Access:
http://support.microsoft.com/kb/290792/

Steve
(e-mail address removed)

Ken Snell said:
Check out TransferSpreadsheet in Help file regarding importing EXCEL data
into ACCESS.

--

Ken Snell
<MS ACCESS MVP>

Steve said:
1. What tool and script do I use to automate the importing of data from
various Excel spreadsheets into previously set up Access Tables?

2. What tool and script do I use to automate the Exporting of data from
various Microsoft program sources [Outlook Contacts, etc.] into
previously
set up Excel spreadsheets?

Grateful for your help,

Steve Walsh
MarketCounsel.org
866-261-3886
Click to expand...
Click to expand...
Click to expand...
 
Back
Top