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

Apr 25 '07 #1

pks00

What are you using to import/export excel file

If in code, are you using DoCmd.TransferSpreadsheet?

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

Apr 26 '07 #2

JHNielson

What are you using to import/export excel file

If in code, are you using DoCmd.TransferSpreadsheet?

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.TransferSpreadsheet. 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?

May 1 '07 #3

JHNielson

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

This is the code I'm using:

May 1 '07 #4

JHNielson

Anybody have any ideas?

May 1 '07 #5

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.

May 1 '07 #6

pks00

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

May 2 '07 #7