View Single Post
  #2   Report Post  
Bill Manville
 
Posts: n/a
Default

Can you give us a better idea of what you are attempting to do?
Also mention which version of Office you are using, please.

The most usual way of "linking" Excel and Access is to run queries in
Excel (Data / Import External Data / New Database Query) to import
selected information from an Access database into an Excel worksheet
where it can be referenced using formulas (e.g. VLOOKUP) elsewhere in
the worksheet.

If you have information in Excel that you want to make available to the
Access database you can create a table in Access that is linked to the
Excel file (File / Get External Data / Link Tables), but I would not
suggest using that as the long term way of dealing with your data -
usually better to import it into Access and keep it there.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup