access Importing

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dimpie - 13 Sep 2007 15:26 GMT

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!!!

Reply to this Message

Alex Dybenko - 13 Sep 2007 17:04 GMT

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

Signature

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

>I want to import a file wih extention .res to access.
>
[quoted text clipped - 7 lines]
>
> Thanks a lot!!!

Reply to this Message

dimpie - 13 Sep 2007 19:52 GMT

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!!

> Hi,
> you can use Name to rename file and then import, or use FileCopy to copy
[quoted text clipped - 11 lines]
> >
> > Thanks a lot!!!

Reply to this Message

Alex Dybenko - 14 Sep 2007 04:26 GMT

Hi,

something like this:

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

docmd.transferdatabase ... strNewName

Kill strNewName

Signature

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

> Hi Alex - Could you please be more clear.
>
[quoted text clipped - 20 lines]
>> >
>> > Thanks a lot!!!

Reply to this Message