Link An ACCESS Table To An EXCEL Workbook

  • Thread starter Thread starter Minitman
  • Start date Start date
M

Minitman

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
 
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
 
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
 
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!
 
What I need to know is how Excel can see an Access table,
Click to expand...

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.
 
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
 
Back
Top