![]() When I run it, I get the error "Run-time error '-2147467259 (80004005)': Could not find installable ISAM.". ![]() So far, here is the VBA I have written (or at least the part of it dealing with the importing into Access). I've been basing my code off of the bulk-insert method (building an SQL "INSERT INTO" statement) that the submitter posted as an edit to this previous StackOverflow question Using Excel VBA to export data to MS Access table. I'm very new to VBA, and I've been trying to write some code in Excel 2016 that will, when a button is pressed, take a range of cells and write them to a table that I've set up in an Access 2016 database.
0 Comments
Leave a Reply. |