Push data into the SQL database
3 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
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 Commenti
Risposte (0)
Vedere anche
Categorie
Scopri di più su Database Toolbox in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!