Dim cn1 As New OleDbConnection( _Re: Ceating a table in a projects subfolder by not specifiing the whole path(VFP)....
- From: "Cindy Winegarden" <CindyWinegarden@xxxxxxxxxxxxxxxxx>
- Date: Sun, 8 Oct 2006 21:16:36 -0400
Hi Lenard,
First, be sure you're using the latest FoxPro and Visual FoxPro OLE DB data
provider, downloadable from msdn.microsoft.com/vfoxpro/downloads/updates.
A lot depends on whether you're working with a Database Container (DBC file)
or FoxPro "free" tables. The connection string for free tables points to a
directory so you'd need one connection for the incoming data and one for the
outgoing data. With a DBC you can write to a different directory than where
the DBC is located as follows:
Dim cn1 As New OleDbConnection( _
"Provider=VFPOLEDB.1;Data Source=D:\Temp\TestFolder.dbc;")
cn1.Open()
'-- Make some VFP data to play with
Dim cmd1 As New OleDbCommand( _
"Create Table D:\Temp\TestFolder\TestDBF (Field1 I, Field2 C(10))", cn1)
cmd1.ExecuteNonQuery()
cn1.Close()
--
Cindy Winegarden MCSD, Microsoft Most Valuable Professional
cindy@xxxxxxxxxxxxxxxxxxx
<lenard.palko@xxxxxxxxx> wrote in message
news:1160210573.738783.130910@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I'm working on a project in VFP , and I need to copy a table with
SELECT into another table, but with this the table is created in the
root-folder of the project and I need to create it in a subfolder.
I would appreciate your help .. Thnx
.
- References:
- Ceating a table in a projects subfolder by not specifiing the whole path(VFP)....
- From: lenard . palko
- Ceating a table in a projects subfolder by not specifiing the whole path(VFP)....
- Prev by Date: Re: Ceating a table in a projects subfolder by not specifiing the whole path(VFP)....
- Next by Date: Re: MS Office Update to Access 2003 killing me?
- Previous by thread: Re: Ceating a table in a projects subfolder by not specifiing the whole path(VFP)....
- Index(es):
Relevant Pages
|
|
