Divide fields?

A

Alejandra Parra

How can I divide a field that looks like this
Column
data1/data2
data3/data4
d5/d6

So I can have after the query
Column1 Column2
data1 data2
data3 data4
d5 d6
 
X

x

if "/" is consistent seperating the fields
try to convert that to delimited file
in excel...then get external (new excel file) into access
table...
hope this works
 
P

Pieter Wijnen

SELECT LEFT(COLUMN,INSTR(COLUMN,'/') -1) AS COLUMN1,
MID(COLUMN,INSTR(COLUMN,'/')+1) AS COLUMN2
FROM TABLE

ought to do it

HTH

Pieter
 
Top