Search results

  1. L

    Merge all csv files into one file AND add ticker symbol

    Thanks, I will look it up right away. Kind regards Espen
  2. L

    Merge all csv files into one file AND add ticker symbol

    I think I got a workaround... Using a batch code: @echo off setLocal EnableDelayedExpansion for /f "tokens=* delims= " %%c in ('dir/b/a-d *.csv') do ( set FN=%%~Nc set /a N=0 for /f "tokens=* delims= " %%a in (%%c) do ( set /a N+=1 if !N! equ 1 ( echo %%a, id >...
  3. L

    Merge all csv files into one file AND add ticker symbol

    Hi I have found a simple code that will merge all my csv files into one file. But the problem is that QCollector doesn't have symbol in the first column. Therefore the merged file is unusable as it is all one big collection of qoutes without knowing what stock they are representing. Here's...
  4. L

    Create a SQL database from csv files

    Thank you very much guys!! That cleared out a lot. I will try to use the import/export on my SQL Express. BTW: Is it true that the full version of SQL costs thousands of dollars?? Does the express version work when I want to create large databases from stockquotes? Kind regards Espen
  5. L

    Create a SQL database from csv files

    Hello I have worked a lot on VBA in Excel, and would like to test how the result would be if I used SQL instead of hundreds of .csv files. But I have no clue on how to create a SQL database from all my .csv files. I have searched up and down without finding any answers that is relevant...
Back
Top