Text to Columns in Access

Trying to split a column in Access with all fields having the format:

COLUMN:[NUMBER(fixed length) NAME(varying length)]

I see in Excel they have a Text to Columns function which creates two
columns which seperate the NUMBER and NAME. Does Access have this
functionality. Can kick it out to Excel but I'm over the 65,000 rows
and would have to split, etc.

re: Text to Columns in Access

Try
Number: Left(Column,5) assuming this is a 5 digit ficed length
number with leading zeros
Name :Right(Column,Len(Column)-5)
Phil

"jeffgeorge" <kilgore93@aol.com> wrote in message
news:4fbcf414.0312041356.5e9f494b@posting.google.c om...[color=blue]
> Trying to split a column in Access with all fields having the format:
>
> COLUMN:[NUMBER(fixed length) NAME(varying length)]
>
> I see in Excel they have a Text to Columns function which creates two
> columns which seperate the NUMBER and NAME. Does Access have this
> functionality. Can kick it out to Excel but I'm over the 65,000 rows
> and would have to split, etc.[/color]

re: Text to Columns in Access

Thanks Phil. The column looks like this 1000258 SmithCorp. The
numbers are always the same length but the names vary in size and
sometimes have spaces. I think the format of how I posted made it
confusing and don't know if I can get to the solution from your post.
I will try to create two new columns using your post as a guide.





"Phil Stanton" <discussion@stantonfamily.co.uk> wrote in message news:<3fcfaed5$0$99368$65c69314@mercury.nildram.ne t>...[color=blue]
> Try
> Number: Left(Column,5) assuming this is a 5 digit ficed length
> number with leading zeros
> Name :Right(Column,Len(Column)-5)
> Phil
>
> "jeffgeorge" <kilgore93@aol.com> wrote in message
> news:4fbcf414.0312041356.5e9f494b@posting.google.c om...[color=green]
> > Trying to split a column in Access with all fields having the format:
> >
> > COLUMN:[NUMBER(fixed length) NAME(varying length)]
> >
> > I see in Excel they have a Text to Columns function which creates two
> > columns which seperate the NUMBER and NAME. Does Access have this
> > functionality. Can kick it out to Excel but I'm over the 65,000 rows
> > and would have to split, etc.[/color][/color]

re: Text to Columns in Access

Excellent Phil. Entered my expressions and columns are seperated. gracias.



"Phil Stanton" <discussion@stantonfamily.co.uk> wrote in message news:<3fcfaed5$0$99368$65c69314@mercury.nildram.ne t>...[color=blue]
> Try
> Number: Left(Column,5) assuming this is a 5 digit ficed length
> number with leading zeros
> Name :Right(Column,Len(Column)-5)
> Phil
>
> "jeffgeorge" <kilgore93@aol.com> wrote in message
> news:4fbcf414.0312041356.5e9f494b@posting.google.c om...[color=green]
> > Trying to split a column in Access with all fields having the format:
> >
> > COLUMN:[NUMBER(fixed length) NAME(varying length)]
> >
> > I see in Excel they have a Text to Columns function which creates two
> > columns which seperate the NUMBER and NAME. Does Access have this
> > functionality. Can kick it out to Excel but I'm over the 65,000 rows
> > and would have to split, etc.[/color][/color]