Link An ACCESS Table To An EXCEL Workbook

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Minitman - 01 Mar 2005 05:19 GMT

Greetings,

I have an Excel workbook with a customer list that needs to be linked
to several different workbooks. I have been told that I need to move
the customer list to Access instead.

Is this possible?

If so, how is it done?

Any information would be appreciated

TIA

_Minitman

Reply to this Message

Naresh Nichani MVP - 01 Mar 2005 06:02 GMT

Hi:

One way to do this is to Import the Excel worksheet as an Access table. In
Database Window right click and click Import..., IN Files of Type select
"Microsoft Excel (*.xls) and follow the steps.

You can also link to a Excel workbook - the difference between Import and
Link is that in Link data is still stored in Excel workbook and changed in
the Excel workbook. In Import Access table has a copy of the data and
changes made in Access will not impact Excel at all.

Regards,

Naresh Nichani
Microsoft Access MVP

> Greetings,
>
[quoted text clipped - 11 lines]
>
> _Minitman

Reply to this Message

Minitman - 02 Mar 2005 02:14 GMT

Hey Naresh,

You misunderstand, I need to see the Access table IN Excel It is the
first step in converting all of my Excel spreadsheets to Access. But
at this time, that is to big of a project, so I am starting with
something small like the customer list.

What I need to know is how Excel can see an Access table,

TIA

-Minitman

>Hi:
>
[quoted text clipped - 27 lines]
>>
>> _Minitman

Reply to this Message

DL - 06 Mar 2005 00:20 GMT

Your Q may be better posted to an Excel ng.
You can import an Access table into Excel, but I have a feeling you wish to
'lookup' data on a table within Excel. something I've not had the need to
do.
When I converted my bus to Access I had to run my previous app. whilst I
built the the Access. Then convert and import data into Access it took me
some two weeks, over a holiday period - no holiday!

> Hey Naresh,
>
[quoted text clipped - 40 lines]
> >>
> >> _Minitman

Reply to this Message

John Nurick - 08 Mar 2005 06:26 GMT

>What I need to know is how Excel can see an Access table,

That is an Excel question. You can use the Import External Data command
on Excel's Data menu, or write Excel VBA code to retrieve the data via
DAO - or ask in an Excel newsgroup.

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

Reply to this Message

Minitman - 13 Mar 2005 18:56 GMT

Thanks for the replies. I was afraid this was going to have to go to
an Excel NG for posting. Sorry I couldn't reply sooner - I am
reco-operating from eye surgery (both laser and Glaucoma).

I will try the Excel NG's and see if anyone there has any ideas.

-Minitman

>>What I need to know is how Excel can see an Access table,
>
>That is an Excel question. You can use the Import External Data command
>on Excel's Data menu, or write Excel VBA code to retrieve the data via
>DAO - or ask in an Excel newsgroup.

Reply to this Message