Need Help to solve runtime error '2147217904 (80040e10): Too few parameters'

[katrinkerber]

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

[katrinkerber]

sorry guys, just found the reason for the error! the column headings of the spreadsheets were incorrect. sorry if anyone wasted their time to read through the above post!

Kat

[MMcCarthy]

sorry guys, just found the reason for the error! the column headings of the spreadsheets were incorrect. sorry if anyone wasted their time to read through the above post!

Kat

No problem Kat.

Glad you figured that out.