开发者

Export table from Access to Oracle converts number to Varchar how to make it stop doing that?

开发者 https://www.devze.com 2023-02-20 21:03 出处:网络
I have a table in Access 2007 with various number columns, but when i export the table from Access all the number fields are converted to 开发者_如何学Pythonvarchar2. I am using an Access odbc for ora

I have a table in Access 2007 with various number columns, but when i export the table from Access all the number fields are converted to 开发者_如何学Pythonvarchar2. I am using an Access odbc for oracle


Use Number for Data Type and for field size use decimal

0

精彩评论

暂无评论...
验证码 换一张
取 消