[QODBC-Desktop] How to Insert information from MS Excel spreadsheet to QuickBooks using QODBC
Posted by Jack - QODBC Support on 02 November 2015 01:05 PM
How to insert employee time information from MS Excel time spreadsheet into QuickBooks using QODBC
You cannot perform insert/update operations directly in MS Excel because Excel is just exporting tables in the spreadsheet. Excel is not creating link tables like MS Access. If you want to insert/update using MS Excel, then you need to use MS Query, which will execute the statement you enter in the editor, or you can write VBA code in excel.
Please refer article for how to write SQL statements using MS Query: Microsoft Office with MS Query and QODBC.
You can use ADO in VB connection to connect to QuickBooks via VBA in MS Excel.
Please refer to the sample code for inserting records through VBA:
Please Note: All query values are coming from sample company files. Please change it according to your company file value before using them.
Please click here to download a sample MS Excel file.