Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ed9teen
Starting Member
6 Posts |
 Posted - 2008-01-11 : 07:32:42
|
| Hi, i've making codes to transfer my data from Access database to SQL database but my program work fine but i can't insert the data from access database... what is the conflict between two is this below of datatype of something messing in my codes..here is my codes...INSERT INTO magpatoc.dbo.RSOTransferSELECT *FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','c:\CopyOfRSODB.mdb';'admin';'', FinalCustItemRSO) can anyone help me...ed9teenMagnaza |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-01-11 : 07:38:37
|
| You should make sure that the datatype of columns are identical or you need to convert to coresponding datatypeMadhivananFailing to plan is Planning to fail |
 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-01-11 : 08:15:28
|
| moved from script library_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com <- new version out |
|
|
|
|
|
|
Help Sql Statement..