EXPORTING Excel that is Reimportable

[JHNielson]

I have a db that exports a file as an Excel. I want users to be able to make changes to that excel and then re-import it.

I am running into a problem, I want users to see the Logical Names (Captions) so that they can see names they will recognize. But when I try to import the sheet without headings, I get an Field 'F1' doesn't exist error. My research points ot the problem being that there are no headings...

So i wondered if there is a way to export the captions and the field names.
Or is there some other option I haven;t thought of?

Thanks

[pks00]

What are you using to import/export excel file

If in code, are you using DoCmd.TransferS preadsheet?

if u use that then u can specify whether excel file has headings or not. That should get round your problem

[JHNielson]

What are you using to import/export excel file

If in code, are you using DoCmd.TransferS preadsheet?

if u use that then u can specify whether excel file has headings or not. That should get round your problem

Yes, I am using DoCmd.TransferS preadsheet. But I get an error. It gives me an error like....No fieldname for F1 found....

That's the problem I'm having...
Any ideas around this or how to fix it?

[JHNielson]

To be specific i get a "Field F1 Doesn't exist in destination table"

This is the code I'm using:

       DoCmd.TransferSpreadsheet acImport, 5, "DLU-Import", filename, False, "A2:CQ3000"

[JHNielson]

Anybody have any ideas?

[Rabbit]

I think you'll have to either just export using the field names and import with the field names or you can import into a placeholder table and use a query to rename the fields before appending them to the main table.

[pks00]

Can u create columns in your xls file then import it but specify it has columns