splitting table field with street #'s and names

[Guest]

Hello,

I need to split street numbers and names into separate
fields in an access table. Can someone help me?

Merci!

 

[Tom Wickerath]

For splitting names, it's pretty difficult to beat the versatility of an add-in called Splitter
for Microsoft Access:
http://www.infoplan.com.au/splitter/

Yes, you can split names using combinations of the Left, Mid & InStr functions, but you may have
a lot of cleanup still to do, especially if the names include surnames and/or titles. An easier
alternative is to export the table to Excel, add a column after the name, and then use Data >
Text to Columns... and follow the wizard. You may even be able to split your address data the
same way, although it's hard to say without first seeing some sample data.

Tom
_______________________________________


Hello,

I need to split street numbers and names into separate
fields in an access table. Can someone help me?

Merci!

 

[Guest]

I'd like to see this add-in, but the link you posted doesn't appear to work. Do you have an
alternate?
gm

 

[Douglas J. Steele]

The link works fine for me.

Try again.

 

[doco]

Me too!

I'd like to see this add-in, but the link you posted doesn't appear to
work. Do you have an
alternate?
gm

 

[Guest]

I'd like to see this add-in, but the link you posted doesn't appear to work. Do you have an
alternate?
gm

Yep, it's working now, must have been a temporary problem..
gm