Re: Spilt comma delimited field in a MS Access table

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Before you import the data, use Excel and parse the string into multiple
fields.

In Access, you can use a series of queries to append sets of data from your
input values (either a linked or imported table) to your final table design.
The first query would "gather" Application and FirstColumnOfServerName, the
second would pull in Application and SecondColumnOfServerName, the third...

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP
http://mvp.support.microsoft.com/

Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/


"wytco0" <wytco0@xxxxxxxxx> wrote in message
news:1194688978.747371.131030@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I have a table that conatins 2 fields, the first is an application
name and the second contains a list of servers separated by commas.

I need to change this so that I have a list of application-server
pairs.

I am only a basis access user and I have not been able to work out how
to do this.

I am getting the original data from an excel spread*** that someone
else is providing and I cant get them to change the format !

example:

This is how it looks now
App Servers
------------------ -----------------------------------
Application 1 Server1, Server2, Server3

And I need
App Servers
------------------ -----------------------------------
Application 1 Server1
Application 1 Server2
Application 1 Server3


Any ideas, preferably simple ones !


Thanks


.

Quantcast