Something like Data/Text to Columns

[xynon]

Hi everyone,

I am in desperate need of help. I have a huge table in Access that is too big for Excel. I need to do something like Data/Text to Columns in Excel, but in Access. For example 1/2/3 needs to be divided seperately in their own columns. Any way to do this? Thanks in advance for the help!

 

[DataMiner]

Just use a make-table query. Use a string function in the query to separate out the data into the columns you want. Not sure I understand your example -- are you saying that the field delimiter is "/"? If so, you can use the instr function to find where the slashes are located, and then the left and/or mid functions to separate out the data you want.

For example, to extract the "2" out of "1/2/3", you could use
mid(x,instr(1,x,"/")+1,1)

Alternatively, if this is a one-time thing, why not just cut your table down into several smaller, excel-sized tables, use the convenient text-to-columns thing in excel, and then merge back into one big table in access?