Excel read .dat files?

[mapakunk]

Does anyone know if you can link a excel workbook to a .dat file? I need to import data from impact Encore to get Accounts Payable sorted by due date alone

 

[sen_edp]

hello

open the file with excel and use text import wizzard



_________________
Best Regards,<font color="blue"><font size=+1><font color="red"> Andreas
This message was edited by sen_edp on 2002-05-08 14:06

 

[mapakunk]

if I can do that, is there a way to link to this type of file using a data query that will automatically refresh every time I open the file?

 

[sen_edp]

go to Menu ->Data ->Get external Data->
Import Text File

You can set up the import delimiters

and then every time you open it set automatic refresh

 

[mapakunk]

Thanks a bunch!!!