self.svars in code/export-msaccess-sql.py :
self.svars = {
'dao_types': {
1: "Boolean",
3: "Integer",
4: "Long",
5: "Currency",
7: "Single",
8: "Double",
9: "Date",
10: "Text",
11: "Binary",
12: "Text"
}}
has to be corrected to something like the following:
self.svars = {
'dao_types': {
1: "Boolean", # dbBoolean
2: "Byte", # dbByte
3: "Integer", # dbInteger
4: "Long", # dbLong
5: "Currency", # dbCurrency
6: "Single", # dbSingle
7: "Double", # dbDouble
8: "Date", # dbDate
9: "Binary", # dbBinary
10: "Text", # dbText
11: "Binary", # dbLongBinary
12: "Text" # dbMemo
}}
see: DataTypeEnum enumeration (DAO)
P.S. Thanks! MSAccessToSQL is a great (time-saving) tool for my current project - it's right to the job - I'm using it together with AI-tools to generate some boiler-plate code on C#.
self.svarsincode/export-msaccess-sql.py:has to be corrected to something like the following:
see: DataTypeEnum enumeration (DAO)
P.S. Thanks!
MSAccessToSQLis a great (time-saving) tool for my current project - it's right to the job - I'm using it together with AI-tools to generate some boiler-plate code on C#.