ANmarS - Search results

Excel/VBA expert since Sep 1997 (20 years 9 months)

We are moving ...

We are moving to another location, better, faster and more resources .... check it out ANmar.Systems

2 Q & A posts tagged with Access

Sat
Apr 25
2009

MS Office 07 Excel/Access question 10 pts best (right!~)answer?

how do you LINK (not import) an excel worksheet to an Access Database that is already in existence (this database was created by importing data from a separate excel worksheet). I'm stumped! Will award 10 pts best answer! :-)


Answer

When you open Access, and create your database
Go to External Data > Excel
And in the wizard, select the third option (Link to the data ...)

This will create a table that is linked to the Excel spreadsheet.


VBAXLMan

Saturday 4/25/2009 9:00:15 PM
Sun
Apr 23
2006

Where can I find the file WD H-4.mdb?


Answer

It is Microsoft Access database file, did you try to google it?

Just search for that full file name in Google or yahoo


Good luck

Sunday 4/23/2006 4:42:31 PM

Tags

History