spilting fields when import??

[Kelly Lim]

Dear anyone...
When i import Excel file to Access.....
Example: "Name" in a column in the Excel....then it appears one column
too in
Access.....
but in my access....i need to spilt them into "First Name, Middle
Name, and Last Name"...as its a "Reserve word" for "Name" which is not
recommended to use.........
how can i spilt them in Access when i import from Excel since there are
hundreds of data in the file/database....

Need help asap since im working on my database now...
Best to help me step by step....
Thanks a whole loads......

 

[David Lloyd]

Kelly:

I see to possible approaches. One, you could alter the Excel worksheet to
add columns for the First, Middle, and Last names and write functions to
parse (string functions) the values from the Name column. Two, you could
create a second table in Access with the First, Middle and Last name fields
(as well as all the other fields) and write a query to move the data from
original Excel import table into the new table. Again, you would need to
write functions to parse the First, Middle and Last names from the Name
field.

I once had to parse a name field into its parts as you are doing. Depending
on the data, it can be complex, because you have to account for people
without a middle name, two word last names (Van Ness), etc.

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


Dear anyone...
When i import Excel file to Access.....
Example: "Name" in a column in the Excel....then it appears one column
too in
Access.....
but in my access....i need to spilt them into "First Name, Middle
Name, and Last Name"...as its a "Reserve word" for "Name" which is not
recommended to use.........
how can i spilt them in Access when i import from Excel since there are
hundreds of data in the file/database....

Need help asap since im working on my database now...
Best to help me step by step....
Thanks a whole loads......

 

[David Lloyd]

Kelly:

You may also want to reference the following KB article for the code related
to parsing the Name field.

http://support.microsoft.com/default.aspx?scid=kb;en-us;168799

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


Dear anyone...
When i import Excel file to Access.....
Example: "Name" in a column in the Excel....then it appears one column
too in
Access.....
but in my access....i need to spilt them into "First Name, Middle
Name, and Last Name"...as its a "Reserve word" for "Name" which is not
recommended to use.........
how can i spilt them in Access when i import from Excel since there are
hundreds of data in the file/database....

Need help asap since im working on my database now...
Best to help me step by step....
Thanks a whole loads......