Question Linking Access query to Excel

[ph00086]

Hi,

I have a database and an excel sheet which i want to link. The database is used to input part numbers and the amount produced, along with a query that can sum the total number of parts for a certain day and shift. The excel sheet records the total number of parts and any ones that were scraped and gives a percentage of OK parts.

My question is how do i link the data inputted in the database so that the excel sheet updates on a daily basis?

If i haven't been detailed enouogh please say and i'll try and be mor specific.

Thanks

 

[Trevor G]

Welcome to the Forum, Open your Excel Workbook and then Select the Data Tab and you can find the Link to Access in there it is just a case of selecting the Database and then the query.

If using 2003 or earlier then look at the Data Menu and New Query.

 

[ph00086]

I've tried that, sorry maybe wasnt specific enough.

I only want to link the total parts produced not the individual part numbers and parts produced. At the moment the query doesnt save the information it produces and when i try to use "Make a Table" it just deletes the previous table and makes a new one each time. I would like the data produced by the query to be saved in a table so that I have coloums "Date" and "Total Produced" which i then could link to excel more easily.

Thanks

 

[Trevor G]

From your query you can then add totals (Groupings) then you could run 2 types of queries, one to delete (empty the table) then another to append the totals, that should give you the solution you are after.

You can run the queries either from Access or Excel with a little VBA or MACRO from the database.