[AccessD] Manipulate AC95 mdb files without converting

You can also open an Excel Spreadsheet using the JET OLE DB Provider
to read into a Access table, removing the header record , just set a 
reference
to ADO, should work with 95.  You could modify this to use individual
sheets or ranges.  You might get away with using linking an xls file
through the Link Manager as a table, never tried it with access 95
I skipped that version.

ADO version

oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
           "Data Source=c:\somepath\mySpreadsheet.xls;" & _
           "Extended Properties=""Excel 8.0;HDR=Yes"""
Where "HDR=Yes" means that there is a header row in the cell range
(or named range), so the provider will not include the first row of the
selection into the recordset.  If "HDR=No", then the provider will include
the first row of the cell range (or named ranged) into the recordset.

ExcelADO demonstrates how to use ADO to read and write data in Excel 
workbooks

http://support.microsoft.com/default.aspx?scid=kb;en-us;278973

Then write table back to excel with ADO into specific Cells.

Careful this is Excel based.
Import data from Access to Excel (ADO)  single worksheet
http://erlandsendata.no/english/index.php?d=envbadacimportado

Kevin Waddle wrote:

>Anita,
>
>I'm sorry I didn't make it clear what I am trying to do.
>
>But your suggestion pointed me in the right direction.
>
>I am trying to import data from an Excel file into the AC95 db.
>
>What I ended up doing is creating an Access Object within Excel and running
>a RunSQL command on each line in the Excel Sheet.
>
>Thank you,
>Kevin
>
>
>355/113 - Not the famous number Pi, but a great simulation!
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Anita Smith
>Sent: Sunday, July 01, 2007 10:26 PM
>To: Access Developers discussion and problem solving
>Subject: Re: [AccessD] Manipulate AC95 mdb files without converting
>
>Kevin
>You should be able to simply open the database with any later versions of
>Access and enter data directly into it.
>Anita Smith
>Australia
>
>
>  
>
>>Access Guru's,
>>
>>I have a client that uses a VB application that creates and uses an 
>>Access
>>95 mdb.
>>
>>He would like to add data directly to the mdb from Access 2002 or Excel.
>>
>>Is it possible, directly or through an add-in, to manipulate data in 
>>an Access 95 file?
>>
>>Thank you,
>>Kevin
>>
>>    
>>
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada