Deb Jackson
asked on
QB data to MS Access - Update Query and add run increment
Write SQL or VB in MS Access to do the following:
1) Populate updated (new Sales Orders) QB order data (specific field names already identified) to existing table based on Greater than newest Timestamp of previous data load. Original SQL Query attached, cannot construct the Update Query to success.
2) Automate the Update Query to run incrementally every 5 minutes
3) Run Update Query when QB is closed. Currently QB must be open.
All this is one way between MS Access database and QODBC.
I have attached a sample of the output data from QB as well as the Append script to populate the Master Table. We cannot overwrite this data, only add to it. The processes within the MS Access program will do the data cleanup.
Master-Data-Query-from-QB.docx
Sample-Layout-of-Master-Data.xlsx
1) Populate updated (new Sales Orders) QB order data (specific field names already identified) to existing table based on Greater than newest Timestamp of previous data load. Original SQL Query attached, cannot construct the Update Query to success.
2) Automate the Update Query to run incrementally every 5 minutes
3) Run Update Query when QB is closed. Currently QB must be open.
All this is one way between MS Access database and QODBC.
I have attached a sample of the output data from QB as well as the Append script to populate the Master Table. We cannot overwrite this data, only add to it. The processes within the MS Access program will do the data cleanup.
Master-Data-Query-from-QB.docx
Sample-Layout-of-Master-Data.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER