Search found 73 matches: adoimportfromdbf

Return to advanced search

Re: DBF to Excel Sheet, without Excel, using ADO ?

using your Sample i got


Obviously the file should be an existing and valid xlsx file. Otherwise with what ADO connects?
If the file is a valid xlsx file, FW_AdoImportFromDBF() works.
by nageswaragunupudi
Wed Aug 09, 2023 7:40 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: DBF to Excel Sheet, without Excel, using ADO ?
Replies: 50
Views: 2301

Re: DBF to Excel Sheet, without Excel, using ADO ?

does FW_AdoImportFromDBF() work when use Did you not try? Well, this works: function foo()   local oCn, oRs   oCn   := FW_OpenADOExcelBook( TrueName( "some.xlsx" ) )   if oCn == nil      ? "failed to open"...
by nageswaragunupudi
Tue Aug 08, 2023 4:24 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: DBF to Excel Sheet, without Excel, using ADO ?
Replies: 50
Views: 2301

Re: DBF to Excel Sheet, without Excel, using ADO ?

hi, does FW_AdoImportFromDBF() work when use   cTable := LOWER( cFileNoExt( cDbf ) )   oCon    := TOleAuto() :New( "ADODB.Connection" )   oCon:Open( "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + ;                   cTable + ';Extended Prop...
by Jimmy
Tue Aug 08, 2023 11:36 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: DBF to Excel Sheet, without Excel, using ADO ?
Replies: 50
Views: 2301

Re: FW_AdoImportFromDBF

my dbf using codepage 'PLMAZ'
and I want to move dbf to mysql or mssql where codepage is 'PLWIN'
by kajot
Tue Oct 11, 2022 3:13 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: FW_AdoImportFromDBF
Replies: 4
Views: 287

Re: FW_AdoImportFromDBF

maybe, there is codepage parameter


No.
Can you please explain what exactly are you looking for?
Are you working with MSSQL?
by nageswaragunupudi
Tue Oct 11, 2022 2:29 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: FW_AdoImportFromDBF
Replies: 4
Views: 287

Re: FW_AdoImportFromDBF

thank, it works

maybe, there is codepage parameter
by kajot
Tue Oct 11, 2022 1:33 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: FW_AdoImportFromDBF
Replies: 4
Views: 287

Re: FW_AdoImportFromDBF

Yes.
Syntax:
Code: Select all  Expand view
FW_AdoImportFromDBF( oCn, cDbf, [cAdoTable], [cColPrefix], [nMultiRowSize], [aFields], .F. )


Use .F. as 7th parameter
by nageswaragunupudi
Mon Oct 10, 2022 6:48 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: FW_AdoImportFromDBF
Replies: 4
Views: 287

FW_AdoImportFromDBF

can you turn off so that the function FW_AdoImportFromDBF does not add column ID

best regard
kajot
by kajot
Mon Oct 10, 2022 5:29 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: FW_AdoImportFromDBF
Replies: 4
Views: 287

Re: DBF to SQL

FW_AdoImportFromDBF() creates and imports the dbf. If the table already exists on the server, the function prompts if the table is to be overwritten. Does not matter 140 tables or 1400 tables we can import in one go. Example: RDDSETDEFAULT( "DBFCDX" )oCn := FW_OpenAdoConnection(...
by nageswaragunupudi
Thu Apr 15, 2021 3:11 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: DBF to SQL
Replies: 14
Views: 1616

DBF to SQL

I know this is a repeat question, but I also know work was done on this issue. The current number of features entices me to perhaps convert my existing application to SQL from DBF. I know the FW_AdoImportFromDBF( ) exists, and I've seen a couple of posts on the forum that show it. However, I have no...
by TimStone
Wed Apr 14, 2021 9:57 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: DBF to SQL
Replies: 14
Views: 1616

Re: error con adoimportfromdbf

nageswaragunupudi wrote:Still, we can override by specifying one of the other existing fields as the primary key.

Mr. Rao :
Into the importation How specify an field as the primary key ?

Thank you Master for your response
by artu01
Sun Aug 23, 2020 3:44 am
 
Forum: FiveWin para Harbour/xHarbour
Topic: error con adoimportfromdbf
Replies: 4
Views: 683

Re: error con adoimportfromdbf

By default, the function adds an autoincrement field ID as the primary key, if the DBF does not already have an auto-inc field. Many a time we forget or ignore that is essential to have a primary key when we migrate to SQL databases and this feature simplifies the process of migration. Still, we can...
by nageswaragunupudi
Sun Aug 23, 2020 3:16 am
 
Forum: FiveWin para Harbour/xHarbour
Topic: error con adoimportfromdbf
Replies: 4
Views: 683

Re: error con adoimportfromdbf

Mr. rao, thank you, i'll try your recommendation Another question, seeing the table that you imported, i notice the column id but my dbf doesn't have that field? Excellent photo of the penguin seeing the camera! This worked for me without any errors and should work for you also.   oCn := FW_OpenAdoC...
by artu01
Sat Aug 22, 2020 4:47 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: error con adoimportfromdbf
Replies: 4
Views: 683

Re: error con adoimportfromdbf

This worked for me without any errors and should work for you also.   oCn := FW_OpenAdoConnection( { "MSSQL", xSource, xCatalog, xUserID, xPassword }, .t. )   if oCn == nil      ? "connect fail"      return nil  ...
by nageswaragunupudi
Sat Aug 22, 2020 2:10 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: error con adoimportfromdbf
Replies: 4
Views: 683

error con adoimportfromdbf

Mr. Rao Estoy importando mi tabla mcodi.dbf a MSSQL de esta forma:   xPROVIDER := "SQLOLEDB"                xSOURCE   := "WIN-JET3FF08IIT"                  xPASSWORD := "Pysa2019.  xCATALOG  := "PysaBD"                  xUSERID   := "sa"  xConnect  := 'Pr...
by artu01
Fri Aug 21, 2020 10:20 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: error con adoimportfromdbf
Replies: 4
Views: 683
Next

Return to advanced search