Hello,
I need help to solve a runtime error that keeps reocurring every time I try to convert an Excel file into an Acess File. I have looked through many forums trying to find help, but I have almost no specific IT knowledge and so don't really speak the language. Apologies up-ront if I sound dumb.
I am working for a company that has a online clothing shop website. All new data of products is always entered into an Excel Spreadsheet and needs then to be converted into a .mdb file, which is then uploaded. The conversion used to work fine, but since my last amendments to the spreadsheet, the "prjDataConverter" keeps crashing with the below error message:
run-time error '2147217904 (80040e10): Too few parameters. Expected 2.'
At the Status line at the bottom of the software window it says: [nameofspreadsheet] getting max this is the moment the run-time error occurs.
I hope that is explained okay. I'd like to insert a picture of the error message, but don't know how.
If someone is able to help out nevertheless, this would be very much appreciated, as I will otherwise loose days of work :-(
Thanks up-front,
Kat