How To Link To An ACCESS Table

[Minitman]

Greetings,

I am using Access 2003 for my customer list. I need to access this
Access table from within an Excel 2003 worksheet. I also need to add
names to this Access table from Excel as they become available.

Is this possible and how is it done?

Any help would be most appreciated.

TIA

-Minitman

 

[Tom Ogilvy]

You can start here:

Mr. Erlandsen's site:
http://www.erlandsendata.no/english/index.php?t=envbadac

KB Articles:
http://support.microsoft.com/default.aspx?scid=kb;en-us;295646&Product=xlw
How To Transfer Data from ADO Data Source to Excel with ADO

http://support.microsoft.com/default.aspx?scid=kb;en-us;278973&Product=xlw
SAMPLE: ExcelADO Demonstrates How to Use ADO to Read and Write Data in Excel
Workbooks

http://support.microsoft.com/default.aspx?scid=kb;en-us;257819&Product=xlw
How To Use ADO with Excel Data from Visual Basic or VBA

 

[Gary Brown]

DATA / GET EXTERNAL DATA / NEW DATABASE QUERY
Select MS Database
Select the Access database you want.
Select the table/query you want
Follow the rest of the wizard.

HTH,
Gary Brown

 

[Jamie Collins]

Select MS Database
Select the Access database you want.
Select the table/query you want
Follow the rest of the wizard.

The wizard will not help send updates/new rows to the table. MSQuery is
more suited to read-only operations. For read/write I recommend ADO in
VBA code.

Jamie.

--

 

[Minitman]

Hey Gary,

Thanks for the reply,

However, you misunderstand, I need to Link, not just Get, the data in
the Access table. I also need to add data to that table occasionally

-Minitman

 

[Minitman]

Hey Tom,

Thanks, this looks just like the information that I am looking for.

-Minitman