[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 operation directly in MS Excel because Excel is just exporting table in the spreadsheet. Excel is not creating link table like MS Access. If you want to insert/update using MS Excel, then you need to use MS Query which will execute the statement which you enter in the editor or you can write VBA code in excel.
Please refer article for how to write SQL statement 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 below 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.
Please click here to download sample MS Excel file.