TransferDatbase Method

[Mukesh Patel]

Hi,
I am trying to use TransferDatabase method to transfer some tables in
Msaccess to FoxPro 2.6 (test.dbf) in C:\ drive and it gives me not valid
file name .

DoCmd.TransferDatabase acExport, "Foxpro 2.6", _
"C:\test.dbf", acTable, "Table1"
I also try to built a macro and run but was unsuccessful.

Thank you in advance
Mukesh

[Gary Brown]

C:\Test.dbf must exist in order for this to work.

HTH,
Gary Brown

Mukesh Patel <mukesh...@gage.com> wrote in article
<ellTFHqi$GA.1152@cppssbbsa06>...

[Mukesh Patel]

Thanks
But I want to create this file on run
Thanks again for your help
Mukesh
Gary Brown <GBrow...@Yahoo.com> wrote in message
news:01bf8ac4$3981e360$c096...@rda56718.rdigest.com...

[Gary Brown]

I still think a 'dummy' Foxpro database where you can transfer your tables
on the fly is your best bet. Billy Gates makes life very hard for people
who are trying to use programs other than his beloved MSOffice.

Good Luck,
Gary Brown

Mukesh Patel <mukesh...@gage.com> wrote in article

<OolzjEti$GA.1172@cppssbbsa06>...

[SteveT]

Mukesh ,

In words: Export the Access table "Table1" to the Directory "c:\" a file named "Test.dbf" in dBase III format.

DoCmd.TransferDatabase acExport, "dBase III", "c:\", acTable, "Table1", "Test.dbf", False

Steve

Mukesh Patel <mukesh...@gage.com> wrote in message news:OolzjEti$GA.1172@cppssbbsa06...

[david]

Use "C:\TEST.DBF" and "TABLE1"
sOME OF THE tRANSFERdATABASE methods
can't handle lowercase file names.

Mukesh Patel wrote in message ...

[Mukesh Patel]

Thanks Steve, it really helped a lot and it is now working.
I would like to thanks every body who tried to help me out in this problem
thanks
Mukesh
<SteveT> wrote in message news:ueq$NNui$GA.195@cppssbbsa04...
Mukesh ,

In words: Export the Access table "Table1" to the Directory "c:\" a file
named "Test.dbf" in dBase III format.

DoCmd.TransferDatabase acExport, "dBase III", "c:\", acTable, "Table1",
"Test.dbf", False

Steve

Mukesh Patel <mukesh...@gage.com> wrote in message
news:OolzjEti$GA.1172@cppssbbsa06...
> Thanks
> But I want to create this file on run
> Thanks again for your help
> Mukesh
> Gary Brown <GBrow...@Yahoo.com> wrote in message
> news:01bf8ac4$3981e360$c096...@rda56718.rdigest.com...
> > C:\Test.dbf must exist in order for this to work.
> >
> > HTH,
> > Gary Brown
> >
> > Mukesh Patel <mukesh...@gage.com> wrote in article

> > <ellTFHqi$GA.1152@cppssbbsa06>...