I have to create -- ar runtime -- some dbf in dbase IV format. I am using Visual C# and System.Data.OleDb (I tried also System.Data.Odbc).
My approach is like this:
1/ create oledbconnection with connection string Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\somefolder;Extended Properties=dBASE IV;
2/ create oledbcommand object and setting the commendtext: create table tablename(columnname numeric(13,3)) and perform executenonquery.
The file is created but the column is not exactly as I wanted; instead it's numeric(20,5).
My question is: how to create a numeric data type column exactly the precision and width I specify
Thank you for your time,