Excel read .dat files?

mapakunk · May 8th, 2002, 02:59 PM

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 · May 8th, 2002, 03:05 PM

hello

open the file with excel and use text import wizzard

_________________
Best Regards,
Andreas

[ This Message was edited by: sen_edp on 2002-05-08 14:06 ]

mapakunk · May 8th, 2002, 03:08 PM

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 · May 8th, 2002, 03:15 PM

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 · May 8th, 2002, 03:19 PM

Thanks a bunch!!!

May 8th, 2002, 03:15 PM	#4
sen_edp Board Regular Join Date: Mar 2002 Location: Hellas Posts: 553	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 __________________ Best Regards Andreas

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 8th, 2002, 02:59 PM	#1
mapakunk New Member Join Date: May 2002 Posts: 40	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

May 8th, 2002, 03:05 PM	#2
sen_edp Board Regular Join Date: Mar 2002 Location: Hellas Posts: 553	hello open the file with excel and use text import wizzard _________________ Best Regards, Andreas [ This Message was edited by: sen_edp on 2002-05-08 14:06 ]

May 8th, 2002, 03:08 PM	#3
mapakunk New Member Join Date: May 2002 Posts: 40	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?

May 8th, 2002, 03:19 PM	#5
mapakunk New Member Join Date: May 2002 Posts: 40	Thanks a bunch!!!