Copy data from access database (JET) to sql server problem

[Britoa]

This may or may not be a labview problem, but I have a set of data which has an issue if I try to copy the data from within access (2003) to an mssql (2000 sp3?) database.  I was wondering if anyone else had this problem when trying to move to a different db?

I am just doing a "Insert into sqldb values select * from accessdb" command, which works find from access to access, and from access to sql within sql, but not access to sql from within access. 

[Jared_B]

Britoa,

Are you performing these commands in LabVIEW or from some other DB Admin tool?  I wasn't sure if you were using LV to perform these operations or not, from your last sentence when you said from within access.

[Britoa]

The commands are using access, but I was seeing if anyone else came across such issues with labview saved data (it's a flattened cluster)  The data saves and loads within labview just fine from both SQL and the accessDB, but when trying to move the data from access to sql, I get those issues.  It's... strange.

[Jared_B]

Britoa,

Take a look at this post, it has some links that may prove useful.