Best Practice to get MS Access data into MS Excel

  • Thread starter Thread starter Craig Sira
  • Start date Start date
C

Craig Sira

I have data in an MS Access database that I want to be
able to get into a specific sheet in a workbook without
disrupting the rest of the sheets in the workbook. Is
there a way to set this up without manually opening the
workbook and copy and paste from Access query? The MS
Access gets refereshed on a regular basis and we need to
have this reflected in the MS excel workbooks.

Thank you,
Craig Sira
 
Use Excel 'Data/Get external data' to make the link. Do not format this
sheet at all ie. keep as a simple table that you can link to via pivot
tables or whatever. All you need to do is Refresh the data when
required.
 
Have a look in the help for the SQL keyword 'IN'. You can use it to
specify the Excel worksheet in an UPDATE or INSERT INTO query e.g.

INSERT INTO
[Excel 8.0;database=C:\MyWorkbook.xls;].[Sheet1$G10:H65536]
(MyCol1, MyCol2)
SELECT ColA, ColB FROM Table1
 
Back
Top