Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 12-30-2016, 08:33 PM   #1
ernielippert
Newly Registered User
 
Join Date: Sep 2012
Posts: 13
Thanks: 4
Thanked 0 Times in 0 Posts
ernielippert is on a distinguished road
Import Excel spreadsheet

During import from Excel, the Import Spreadsheet Wizard says <Field 'F7'doesn't exist in destination table "name'>. No import happens.The operation is then terminated by me. This happens whether I try to import into an existing table or let the wizard create a new table. Field names and data types are consistent and the application has been compacted. I have no idea what 'F7'is. Will appreciate your suggestions.
Regards,
Ernie

ernielippert is offline   Reply With Quote
Old 12-30-2016, 10:41 PM   #2
JHB
Have been here a while
 
Join Date: Jun 2012
Location: In the south of Denmark (Jutland), near the German border.
Posts: 7,436
Thanks: 2
Thanked 1,993 Times in 1,949 Posts
JHB has a spectacular aura about JHB has a spectacular aura about
Re: Import Excel spreadsheet

Try to copy the whole Spreadsheet into a new one, that means, open the spreadsheet, select all cells and copies it into a new spreadsheet.
Did you try to import another Spreadsheet?
__________________
If the above post has helped you, why not take the time to say thank you, by pressing the "Thumbs up."
JHB is online now   Reply With Quote
The Following User Says Thank You to JHB For This Useful Post:
ernielippert (12-31-2016)
Old 12-31-2016, 01:35 AM   #3
stopher
AWF VIP
 
stopher's Avatar
 
Join Date: Feb 2006
Location: Southampton, UK
Posts: 2,396
Thanks: 20
Thanked 311 Times in 292 Posts
stopher is a jewel in the rough stopher is a jewel in the rough stopher is a jewel in the rough stopher is a jewel in the rough
Re: Import Excel spreadsheet

I would say the wizard has found a field name that it does not like and has consequently given it a random name F7. This can happen if an illegal name is bening used e.g. one with inappropriate characters. Or if there is more that one field with the same name.

Then of course once the wizard has renamed a field, it can't match it with the destination.

stopher is offline   Reply With Quote
The Following User Says Thank You to stopher For This Useful Post:
ernielippert (12-31-2016)
Old 12-31-2016, 07:36 AM   #4
ernielippert
Newly Registered User
 
Join Date: Sep 2012
Posts: 13
Thanks: 4
Thanked 0 Times in 0 Posts
ernielippert is on a distinguished road
Re: Import Excel spreadsheet

Copying the data to a new spreadsheet worked like a charm. Thanks for the tip. Excuse it if this message appears multiple times. I'm still learning how to reply properly.
Regards,
Ernie

ernielippert is offline   Reply With Quote
Reply

Tags
excel , import

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
import excel spreadsheet hawg1 Modules & VBA 5 05-28-2010 10:05 AM
import and update excel spreadsheet eugz Modules & VBA 1 08-05-2008 05:48 AM
Excel Spreadsheet will not import into Table TBlatnica Tables 6 10-18-2006 12:56 AM
[SOLVED] Import excel spreadsheet lhillberry Tables 5 04-26-2005 11:13 AM
Use a Cmd button to import Excel spreadsheet? andreas_udby Forms 3 08-12-2002 08:13 AM




All times are GMT -8. The time now is 07:50 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post

Is Political Correctness Toxic?

Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World