Hi ClifCamp,
I had a similar problem with the error that you are receiving. I was importing from Excel 97 into Access 97.
What I did was in the DoCmd.TransferSpreadsheet line where I had ,acSpreadsheetTypeExcel97, I ignored the argument and left the space blank.
E.G.
DoCmd.TransferSpreadsheet...
Thanks ddeegan
I spoke to the producers of Goldmine and you do indeed need to purchase an add-on to affect multiple changes via the GM front-end.
Thanks especially for the ContSupp info as I have affected the necessary through Transact SQL.
Regards
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.