Automation of Import/Export function

[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

 

[Ken Snell [MVP]]

Check out TransferSpreadsheet in Help file regarding importing EXCEL data
into ACCESS.

 

[Guest]

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)

Check out TransferSpreadsheet in Help file regarding importing EXCEL data
into ACCESS.

--

Ken Snell
<MS ACCESS MVP>

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

 

[Ken Snell [MVP]]

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>

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)

Check out TransferSpreadsheet in Help file regarding importing EXCEL data
into ACCESS.

--

Ken Snell
<MS ACCESS MVP>

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