saturday - from excel to mysql
Saturday, March 8th, 2008Ha…
I was spending some hour today for transfering data from Excel file to MySQL. I decided to write VBA macro that will write a sqldump file for me since I had three worksheets of about 20K rows and some 5-10 columns each. And I had to fill that data in 4 different MySQL tabels. So LOAD DATA INFILE was really not an option.
Well the thing is that the task was really simple, but the stupid windows registry on my updated XP was driving me crazy. In VBA macro, I was receiving runtime errors when I was trying to use Scripting.FileSystemObject which I needed for making a file…
On anybody’s behalf, there is a command regsrv32.exe %windir%\system32\scrrun.dll which will register the Scripting.FileSystemObject in your registry and from there on, you can browse it your VBA macro editor from options->references to enable it in your procedure. Worked for me 
Then Jan and me went for a lunch. That passed today’s hacking and the database is populated.
Now Samo is comming. My father got a son yesterday - and I got a step brother named Juš so we have to grab some beer
And yes, HAPPY WOMEN’S DAY TO ALL WOMEN.
Especially to my Tanja. Roses are for you :*
