Push data into the SQL database

2016 8 1
0 个回答
10 次查看（30 天）

0 个投票

Hi,
I want to push the table ("NewAllocation": a matrix of type double) into the SQL database server.
dbpath = ['C:\DATAbase.mdb'];
url = [['jdbc:odbc:Driver={Microsoft Access Driver (*.mdb, *.accdb)};DSN='';DBQ='] dbpath];
connfof = database('','mgmtuser','userpw','sun.jdbc.odbc.JdbcOdbcDriver',url);
colnames = {'EffectiveDate','Code','Component_Code','Allocation'};
tablename = 'NewAllocation';
fastinsert(connfof, tablename, colnames, NewAllocation)
My question is, can "fastinsert" or "datainsert" just populate the data as is in a type of double??
Please correct me if I am wrong. But, I think "fastinsert" or "datainsert" convert double into text value when exporting data into the SQL server..
Thanks for your help. Jake

请先登录，再回答此问题。

回答（0 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Data Type Conversion 的更多信息

标签

提问:

Jake
Jake
2016-8-1

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by