Importing Excel into a Table

[Ron]

I have an excel speadsheet that I would like to import
into a Access 2000 database. The spreadsheet that has a
name field which contains a first Name, Last Name and
middle initial. There are 7983 records in this Excel
sheet, and sometimes there is no middle initial. Is there
a way to import this spreadsheet so that the first name,
last name and middle initial are seperate fields in
Access? Thanks for all the information

 

[Adrian Jansen]

If the name column in Excel is only one column, its usually easier to import
it into one field of a temporary table in Access, then use code to parse out
the sensible name strings, using the Split,Left,Mid,Right functions, and
Instr to find the spaces. Write the separated strings into separate fields
in your final table. You will still have to do some manual checking to
correct odd names - entries like Ms De La Silva will trip up most automatic
parsers.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control

 

[Ted hall]

-----Original Message-----
I have an excel speadsheet that I would like to import
into a Access 2000 database. The spreadsheet that has a
name field which contains a first Name, Last Name and
middle initial. There are 7983 records in this Excel
sheet, and sometimes there is no middle initial. Is there
a way to import this spreadsheet so that the first name,
last name and middle initial are seperate fields in
Access? Thanks for all the information
.
It might be easier if before importing the data you

convert it to three different columns in excel. There is
an easly function in excel that does this. highlight the
column with the names in it, and then click on Data at
the top and then text to columns. Prior to doing this
you may want to insert three blank columns, as excel will
need these to put the new data. If you put it in colums
that already have data it will overwrite the data in
those columns. Prior to seperating the names it will ask
you for what to delimit the data on, spaces, comma, or
whatever you have separating first from mi from last. I
have found it is easier to have the data ready before
bringing it in.