Field "F1" does not exist in table (Tablename)

[HelenP]

Hello



I have created a database that allowed the user to import payments from a spreadsheet, put them in a temporary table then append to the main payments table. It worked perfectly but now a while later I have tried to import more payments and I get this error message:

Field "F1" does not exist in destination table "NewPayments"

I have googled it and have tried everything that I have read but still cannot do it

Please help!!!!

Thanks

[ajetrumpet]

more than likely you're doing this in code. I believe, if memory servers, that imports through code assign "F" + index number for field names in the import table or the table that data is appended to.

when you first created the permanent table for the imported payment, the first field was most likely called "F1", either by import or by accident through the interface. You have to fix it manually.

[HelenP]

Thanks for your help

I have sorted out all of the fields that have data in them but it is now saying field "F8" does not exist. F1, F2, F3 etc were the column headings but there is no 8th column.

I cannot set a range to import because it varies. When I set a range to see if it works it worked perfectly (apart from importing loads of empty cells) is there any way of setting a range that only imports when there is data there?

Thanks again

[ajetrumpet]

is there any way of setting a range that only imports when there is data there?

Thanks again

no there isn't Helen. Not easily, anyhow.

if the import has to be dynamic, there is no way you can store the transfer data in one table, unless you're willing to deal with null values.

you can import anything from code into a new table and it will create how ever many "F" fields needed. you might be stuck with importing this way and issuing a dynamic sql execution in code right after it. it is not difficult to grab a field count of a table and loop them to concat them into an sql statement for append purposes.