Rank: Newbie
Posts: 3 
|
Hi, I have things up and running with Excel to Database and Visual Foxpro. these are the setting I now have in the SQL-Flavours.DB-XL.XML file for FoxPro: Code:
<SQLFlavour>
<Code>FOX</Code>
<Name>Microsoft FoxPro</Name>
<DBMSName>Visual FoxPro</DBMSName>
<StoredProcMethod>NONE</StoredProcMethod>
<ExecProcFormat></ExecProcFormat>
<InsertFormat>INSERT INTO {table_name}[br]([br]{fields_csv}[br])[br] VALUES[br] ({values_csv})</InsertFormat>
<FieldNameQualifierStart></FieldNameQualifierStart>
<FieldNameQualifierEnd></FieldNameQualifierEnd>
<GetProcCode></GetProcCode>
<GetTableDefinitionCode></GetTableDefinitionCode>
<StringDelimeter>"</StringDelimeter>
<ReplaceStrings>
<Replace>
<from><![CDATA["]]></from>
<to><![CDATA[" + chr(34) + "]]></to>
</Replace>
</ReplaceStrings>
<Notes />
</SQLFlavour>
Works nicely Mark
|
|
|
|
|
|
Rank: Administration
Posts: 42
|
Awesome Mark - that is great.
We will incorporate into the next release.
We should have the MySQL stored procedure support working too soon .. works fine with MySQL tables already..
Thank you
|
|
|
|
|
|
Rank: Newbie
Posts: 3
|
Originally Posted by: Admin  Awesome Mark - that is great.
We will incorporate into the next release.
We should have the MySQL stored procedure support working too soon .. works fine with MySQL tables already..
Thank you Your welcome We like your XML flavours model :)
|
|
|
|
|
|
Rank: Newbie
Posts: 1 
|
Yep this worked for me
Lovell
|
|
|
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.