Export lis file to Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

HI,
I have 'lis' file "po.lis". When I open it in excel I'm getting:
cell A1:RMC~code~desc~Dd
cell A2:SP ~136 ~SPR~A208
cell A3:SP ~136 ~SPRL~A208
all the data in column A with delimiter ~.

Can I export it to Excel?

thanks,
Shlomit
 
Hi Shlomit,

This looks like a ~-delimited text file. In Excel you can use the
Data|Text to Columns... menu command (or the equivalent in whatever
language you're using); or you can import it into Access with File|Get
External Data|Import...

Either way, in the text import wizard, set the field delimiter to ~ and
the text qualifier to {none}.
 
Back
Top