By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,963 Members | 1,778 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,963 IT Pros & Developers. It's quick & easy.

EXPORTING Excel that is Reimportable

100+
P: 121
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
Share this Question
Share on Google+
6 Replies


pks00
Expert 100+
P: 280
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

100+
P: 121
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

100+
P: 121
To be specific i get a "Field F1 Doesn't exist in destination table"

This is the code I'm using:
Expand|Select|Wrap|Line Numbers
  1.        DoCmd.TransferSpreadsheet acImport, 5, "DLU-Import", filename, False, "A2:CQ3000"
May 1 '07 #4

100+
P: 121
Anybody have any ideas?
May 1 '07 #5

Rabbit
Expert Mod 10K+
P: 12,374
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
Expert 100+
P: 280
Can u create columns in your xls file then import it but specify it has columns
May 2 '07 #7

Post your reply

Sign in to post your reply or Sign up for a free account.