Push data into the SQL database
4 ビュー (過去 30 日間)
古いコメントを表示
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 件のコメント
回答 (0 件)
参考
カテゴリ
Help Center および File Exchange で Database Toolbox についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!