I am trying to import a text file into Crystal 9. I have used text ODBC drivers, MS Assess type connections. Whatever I try, the first record is always skipped. Crystal is using the 1st record as a field label. The file is a straight ASCII file, 80 characters long per record. There are no field labels.
Any suggestions?You have no choice. All fields need label and CR identifies first record as field label.
Showing posts with label drivers. Show all posts
Showing posts with label drivers. Show all posts
Monday, March 26, 2012
Friday, March 23, 2012
Importing MySQL BLOB to MSSQL
Hi all!
I'm trying importing a MySQL database to my MSSQL server. I've donwloaded the MySQL ODBC drivers and I can connect succesfully throught a DSN to my MySQL server. Everything works fine EXEPT my BLOB field. I'm using a BLOB field for storing a binary file.
When I choose preview while importing my bob field is empty.
I'm desperate!
:eek:Viewing a BLOB is pretty much a waste of time. Use DTS or a linked server to move it, and life should be good.
-PatP
I'm trying importing a MySQL database to my MSSQL server. I've donwloaded the MySQL ODBC drivers and I can connect succesfully throught a DSN to my MySQL server. Everything works fine EXEPT my BLOB field. I'm using a BLOB field for storing a binary file.
When I choose preview while importing my bob field is empty.
I'm desperate!
:eek:Viewing a BLOB is pretty much a waste of time. Use DTS or a linked server to move it, and life should be good.
-PatP
Subscribe to:
Posts (Atom)