how can i convert text to columns in access query

		Home \| Contact Us \| FAQ \| Search & Site Map \| Link to Us
		Sign In \| Join \| Other 45 Sites in Network

Discussion Groups Forms Forms Programming Queries Modules / DAO / VBA Reports / Printing Macros Database Design Security Conversion Importing / Linking SQL Server / ADP Multiuser / Networking Replication Setup / Configuration Developer Toolkits ActiveX Controls New Users General 1 General 2

Access Directory Tools Tutorials User Groups

Related Topics

SQL Server Other DB Products MS Office More Topics ...

MS Access Forum / Queries / April 2008

how can i convert text to columns in access query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lionel - 21 Apr 2008 16:48 GMT

I have a text in a query and i need to separate
ex: Peter John Ramos that is on column i need to sepate by the spaces like

column 1 column 2 column3
Peter John Ramos

Reply to this Message

fredg - 21 Apr 2008 17:28 GMT

> I have a text in a query and i need to separate
> ex: Peter John Ramos that is on column i need to sepate by the spaces like
>
> column 1 column 2 column3
> Peter John Ramos

And how would you expect to separate Jean Louis van den Steen III?
Or George Stewart?
or ... etc.

Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Reply to this Message

Sign In

Join

My Latest Posts

My Monitored Threads

My Photo Gallery

My Homepage

Start New Thread

Enable EMail Alerts

Rate this Thread

©2009 Advenet LLC Privacy Policy - Terms of Use

This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.