help please : importing many .txt files in a folder to one table

[mhmaid]

Sorry , it was my typing error
the exact msg that i got when i try to import , for example , the file
Ser-24.XLS is the following

The wizard was unable to access the information in the file
'C:\txtfiles\Ser-24.XLS'.Please check that the file exists and is in the
correct format.

the steps are
File,Get external data,import..and i will choose the file.

 

[Gina Whipp]

mhmaid,

I just tried this and oddly enough, saving the file as tab delimited with a
..xls extension brought about the same message (and was not easy as that was
not the default extension for Excel 2003). When I save the file tab
delimited, I get a .txt extension (The ONLY choice I get) and all is well
for the import. So I wonder can you save your tab delimited file as .txt?
or is this not possible?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[mhmaid]

Hi Whipp
I have tried saving the file as .txt and is accepting .(another file with
the same name , but dif extension is created) (notepad) ,

suppose that its not possible to import the data under the current format.is
there a code or a way to change the extension of all files in one folder from
..XLS to .txt

if there is a way , it means my problem could be solved .
first i change the extension of all the files to .txt
then , by code , import the data to access

any help

 

[Gina Whipp]

mhmaid,

Please tell us when the file is initially dropped out what the extension is.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm