trouble importing csv files to mysql from vbs and access -


I am using the following code based on Remou and Anthony Jones's previous posts and answers. 

  Dim db: DB = "C: \ Documents and Istelungen \ Home \ Anvandungsditain \ Bayveot 4 \ Bayvotc DB5" Daym export DIR: Export DIR = "C: \ Documents and Anstilding \ Home \ Desktop "dim Niryatfail: exportFile = NewFileName (exportDir) dim CN: set cn = CreateObject (" ADODB.Connection ") cn.Open _" provider = Microsoft.Jet.OLEDB.4.0; " & Amp; _ "Data source =" & amp; "Select" DB CNXite [text; HDR = No; Database = "& amp; Indoor & amp; _"; Varnsat = 65001]. "& Amp; Niryatfail & amp;" "the TblAuction 'export file' support functions Function NewFileName (ExportPath) Dim fs Dim NewFileTemp Set fs = CreateObject (" Scripting.FileSystemObject ") NewFileTemp =" CSV "& Amp; Year (Date) _ & amp; Month (Date) & Day (Date) & amp; Sisivi "Nufailnam = Nufailtanp end function

The problem is that when I export files do, quote before the actual data on the headers in the CSV file, while being set to HDR number In my column names, which creates problems during import.

My second problem is that special characters are not saved.

I'm loading data With mysql in: 

  load data Local INFILE 'file' went to fix the entire region defined by ';' I have also tried without escaped by clause.  
 The problem is that the html data in one of the fields , Which means quotes, slashes, etc .. With the reasons for incorrectly importing this data, the date field is entered in the user name field and so on. Can I properly import?  
 I use a scheme.ini as the following Am:  
  [CSV2009427.csv] ColNameHeader = no letter = 65001 format = limited (;) Coll = Article_no four width 19  
 
 and Column headers are still exported. Is it not possible to do this in a way without the need of schema.ini? Ie is able to use the script in a portable manner, where a schema can not be ini at all?

The problem I'm having, when I export the file, csv file The headers are, despite being set on the number of the HDR

I think you need to include the ColNameHeader = False .

Example:

c: \ schema.ini 

  [Blah.csv] ColNameHeader = false Critrset = 1252 format = CSVDelimited Coll = Pence_amount integer

sql code: 

 select  * in [text; Database = C: \]. Crap # csv coins;

Note: The schema.ini file is saved in the same directory in the connection string in SQL as specified by Database .

Result: No headers.


Comments

Post a Comment

Popular posts from this blog

python - Overriding the save method in Django ModelForm -

I'm having trouble overriding a ModelForm save method. I get this error I'm: Exception type: TypeErier Exception Value: Save () found an unexpected keyword argument 'committed' My intentions include a form 3 fields Submit several values ​​for, then create an object for each combination of those areas, and to save each object file models.py class collarsult type (models.Model): id = model. AutoField (db_column = 'icontact_result_code_type_id', primary_key = true) callResult = models.ForeignKey ( 'CallResult', db_column = 'icontact_result_code_id') campaign = models.ForeignKey ( 'campaign', db_column = 'icampaign_id') CALLTYPE = models.ForeignKey ( 'CALLTYPE', db_column = 'icall_type_id') agent = models.BooleanField (db_column = 'bagent', default = true) teamLeader = models.BooleanField (db_column = 'bTeamLeader', default = true) active = models.BooleanField (db_column = Django.form...
Read more

html - CSS autoheight, but fit content to height of div -

I have a div in which there are three children- div in the left and middle div: float: left while true: float: true because it is my layout Actually will spoil, I've used ClearFix Hack: .cf {zoom: 1; }. Cf: First,. Cf: {content: ""; Display: Table; }. Cf: After {clear: both; } It still works, but I want to be the right div an indicator. So it should fill 100% of the parent unit of height. How can I complete this? PS is the full code: & Lt; / Div & gt; & Lt; Div class = "mobile_content" & gt; & Lt; H5 & gt; {{Data.titel}} & lt; / H5> & Lt; Table & gt; & Lt; TR & gt; & Lt; Th & gt; Komponist: & lt; / Th & gt; & Lt; TD & gt; {{Data.komponist}} & lt; / TD & gt; & Lt; / TR & gt; & Lt; TR & gt; & Lt; Th & gt; Instrument: & lt; / Th & gt; & Lt; TD & gt; {{Data.instrumente}} & lt; / TD & gt; & Lt; / TR & gt;...
Read more

qt - How to prevent QAudioInput from automatically boosting the master volume to 100%? -

I have been trying to use Qt5 multimedia to record audio with QAudioInput, however, when I see If QAudioInput is started, it increases the master volume of my sound device to 100%. How can I prevent QAudioInput from changing the master volume? My current development platform is Linux with PalsAdio (with flat audio disabled). How can I use QAudioInput : QAudioDeviceInfo device_info = QAudioDeviceInfo :: defaultInputDevice (); QAudio format format; Format.setSampleRate (44100); Format.setChannelCount (1); Format.setSampleSize (16); Format.setCodec ("Audio / PCM"); Format.setSampleType (QAudioFormat :: SignedInt); Format.setByteOrder (QAudioFormat :: LittleEndian); Std :: cout & lt; & Lt; Device_info.deviceName (). ToUtf8 (). ConstData () & lt; & Lt; Std :: endl; QAudioInput * default_device = new QAudioInput (device_info, format); QIODevice * default_io_device = default_device-> Start (); a QAudioInput.setVolume () method is not you I ...
Read more