New answers tagged csv-file
Probably best to: Import the entire CSV to a table using Import and Export Wizard. Run the query to pull the data you want from the table. Use the Import and Export Wizard to import to the other database. Clean up the CSV import, probably by truncating or deleting the table. Unless you want to use SSIS? Then you can design a package to do it easily ...
From the manual here, you could try experimenting with your my.cnf settings - I know that I had this problem in the past and I eventually got around this by using [client] setting. # added from http://dev.mysql.com/doc/refman/5.6/en/load-data-local.html # to allow for abrowse to load data! loose-local-infile = 1 local-infile = 1 Now, it was either ...
What you want is nearly impossible, no one can know if you want to import '1' as a characters string, n decimal integer, a base-2 integer, an hex integer, a float, a blob, a "boolean", ... You can try heuristic programs, or import them all as strings and run an analysis program like SELECT... ANALYZE TABLE();. It would be easier if the csv had the datatypes ...
It looks like you may have installation issues with ActiveX. To make sure, however, try and find the missing OCX and register it manually. It could be that the registry is having an issue dealing with the file. We have a KB article that directs you how to register, and if it turns out the steps in the article you found don't lead to a resolution, the ...
Based on my experience with ccure 800 in particular, you do need to have MS Excel and all of the supporting MS Office components installed on the same PC as the ccure Administration client. The OCX libraries are required to support the export function.
If you want to get the details out, apparently there's an easier way to do it... Reports-> Journal -> Journal Replay doesn't get you in the database but it does export the times into a text file.
OCX files are part of the ActiveX control. There's something wrong with the application and you need to call the vendor to get it fixed.
Check this example: # cat /tmp/db.txt id,col1,col2 1,23,"dsafsdf" 2,-1,"ghfdhg" 7,9,"strsdrt" # mysql test mysql> CREATE TABLE `test` ( `id` int(11) NOT NULL, `mycol1` int(11) DEFAULT NULL, `mycol2` varchar(20) DEFAULT NULL, PRIMARY KEY (`id`); mysql> load data infile '/tmp/db.txt' into table test fields terminated by ',' optionally enclosed ...
Top 50 recent answers are included