Hello,
I would like to run an Access query or a SQL statement that updates data in my database. The criteria values for the query are stored in an Excel spreadsheet. How can I incorporate this data into my SQL query?
Hello,
I would like to run an Access query or a SQL statement that updates data in my database. The criteria values for the query are stored in an Excel spreadsheet. How can I incorporate this data into my SQL query?
Can you set a link to the Excel sheet? Linked sheet can be used like a table, except can't edit sheet.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
I could try that.