access Importing

[dimpie]

I want to import a file wih extention .res to access.

What i am doing now is i am telling the user to manually change it to .txt
file and then import.

Is there a way that access could take this .res file and convert to .txt
file and then import it into access.

Any advice would be greatly appreciated.

Thanks a lot!!!

 

[Alex Dybenko]

Hi,
you can use Name to rename file and then import, or use FileCopy to copy
..res to .txt, import and then delete if

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

 

[dimpie]

Hi Alex - Could you please be more clear.

I want to do this as a part of automation, so user doen not have to do it.
So how do i code this in VBA???

Thanks a lot!!

 

[Alex Dybenko]

Hi,

something like this:

strFile = "c:\myfile.res"
strNewName="c:\myfile.txt"
filecopy strFile, strNewName

docmd.transferdatabase ... strNewName

Kill strNewName

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com