How To Link To An ACCESS Table
 

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

How To Link To An ACCESS Table
 

You can start he

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

KB Articles:
http://support.microsoft.com/default...46&Product=xlw
How To Transfer Data from ADO Data Source to Excel with ADO

http://support.microsoft.com/default...73&Product=xlw
SAMPLE: ExcelADO Demonstrates How to Use ADO to Read and Write Data in Excel
Workbooks

http://support.microsoft.com/default...19&Product=xlw
How To Use ADO with Excel Data from Visual Basic or VBA

--
Regards,
Tom Ogilvy

"Minitman" wrote in message
...
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

How To Link To An ACCESS Table
 

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



"Minitman" wrote in message
...
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

How To Link To An ACCESS Table
 

Gary Brown wrote:
I also need to add
names to this Access table from Excel
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.

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.

--

How To Link To An ACCESS Table
 

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

On Sun, 13 Mar 2005 21:50:23 -0500, "Gary Brown"
wrote:

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



"Minitman" wrote in message
.. .
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

How To Link To An ACCESS Table
 

Hey Tom,

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

-Minitman



On Sun, 13 Mar 2005 21:46:19 -0500, "Tom Ogilvy"
wrote:

You can start he

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

KB Articles:
http://support.microsoft.com/default...46&Product=xlw
How To Transfer Data from ADO Data Source to Excel with ADO

http://support.microsoft.com/default...73&Product=xlw
SAMPLE: ExcelADO Demonstrates How to Use ADO to Read and Write Data in Excel
Workbooks

http://support.microsoft.com/default...19&Product=xlw
How To Use ADO with Excel Data from Visual Basic or VBA