I have an excel file that won't import into access

E

eyesforthesky

My file was originally a CSV file that was saved into excel format. I tried
to import the file into access and it gives me an error message stating "file
not imported".
 
J

John Nurick

Please provide more information. In particular, are you trying to import
it into an existing table?
 
E

eyesforthesky

No, I was trying to import it into a new table. It looks as though it has
some imbedded spaces. It's a file generated from another source and provided
to me in a csv format. Something is prohibiting it from being imported from
a normal process.
 
J

John Nurick

Access is pretty good at importing well-formed csv files that conform to
Windows conventions. I don't know what you mean by "imbedded spaces",
but spaces in the data are not a problem.

You say "generated from another source and provided to me in a csv
format". Is it a csv file produced by a program somewhere, or has it
been converted into csv from something else? Did it originate on a
Windows system or some other (e.g. mainframe, Mac, Linux...)?

Are you importing it via the user interface (File|Get External
Data|Import) or some other way? Does the file have field names in the
first row? Are these legal field names for Access?
 
Top