change file type via code

External Since: Jun 21, 2009 Posts: 1

I have more than 200 excel sheets files , each file contains one record
these files are created automatically thru our mdis system , which will
export the date of a single record to a xl file ,

what i want to do is , importing the data to a new table in access
when i try to open , i got an error msg , because the files are saved as
text( tab delimited)

in order to be able to import a file to access , i first need to open each
file and save it as of type excel

but is is possible to change the type of all of the files by code
all files are kept in one folder in c drive

hope some ones knows how to do this
thanks

External Since: Jun 21, 2009 Posts: 2

There is no need to open the files in Excel. You can import the delimited
data directly
to an access table. Look in the Access help for "TransferText".

Regards

Kevin

"mhmaid" wrote in message

>I have more than 200 excel sheets files , each file contains one record
> these files are created automatically thru our mdis system , which will
> export the date of a single record to a xl file ,
>
> what i want to do is , importing the data to a new table in access
> when i try to open , i got an error msg , because the files are saved as
> text( tab delimited)
>
> in order to be able to import a file to access , i first need to open each
> file and save it as of type excel
>
> but is is possible to change the type of all of the files by code
> all files are kept in one folder in c drive
>
> hope some ones knows how to do this
> thanks
>