Importing Data

  • Thread starter Thread starter ChrisBat
  • Start date Start date
C

ChrisBat

I'm trying to import a rather large file from MS Excel into Access. I'm
using Office 97, and when I click on the Import table option, the first
step (which shows the various columns and about 25 lines of data) have
all the data screwed up (for example, I've got Customer Name data in my
Telephone number field, Telephone Numbers in Address fields, etc.).
It's not every line, and there does not seem to be any logical pattern
to the chaos (not like that made sense, but I think you know what I
mean...). I've tried everything - saving it as a .CSV, .TXT, .DBF,
.XLS 95, etc. I've gone through my Excel spreadsheet fifteen different
ways, have made sure that there are no problems (i.e. blanks in Date
Fields, etc.), and that everything is where it should be on my
spreadsheet. I'm stumped. I've also tried the Link Tables option, but
I guess the Wizard is similar to the Import table, because the problem
is the same.
Does anyone have ANY suggestions? I need this database up and running
ASAP, and as this dataset is an integral part of the database, I'm
stuck until I get through this.
Thank you in advance,
Chris
 
I've just tried changing my delimiter - tab, comma, spaces, etc. The
problem is that (a) I have multiple data formats (e.g. text, dates,
times, etc) in my spreadsheet, so everything I try causes my data to be
broken up in ways that I don't want, and (b) the problem not only
persists, it got worse - now it took one line of data for one of the
columsn and carried it all the way down the window in the first step of
the import wizard.
I appreciate the suggestion - got any others?
Thanks,
Chris
 
Ah - the mysteries of MS Office - I tried copying and pasting my entire
data set into a new workbook, saved it as a new file, and tried
importing it - and it worked flawlessly.
I just wasted 5 hours....darn....
Later
Chris
 
It looks like you are going to need to export the data to a fixed field
text file and then import that. I don't know Excel well enough to be 100%
sure you can do that, but I bet you can.
 
I wonder what would happen if you added one or more rows without any of
the offending characters?
 
Back
Top