Import .csv to DB2 automatically

[Lukael]

Hello everyone,

I have a .csv file that needs to be imported into a IBM DB2 table. I can import .csv data manually, but I want to do It automatically with VBA, If possible.

I have found some VBA code that might work, but cannot set It right, or It isn't what I think It is.

Code:

Please Login or Register  to view this content.

When I run the code I get an error "[IBM][CLI driver] SQL1337N The service "<50000>" was not found" !

I don't know about OLE DB or ODBC driver - as instructed, I should have one installed on local machine, but can't find anywhere how to download It.

Also, when I use Data>Import External data>Import Data tool in Excel, I can connect to DB2 database directly from Excel, so maybe ODBC driver allready installed ??

My version of DB2 is Express-C 10.5, and Excel 2003.

I'm not sure either If red coloured line of code is basically an SQL command or db2cmd command (which I need exactly as written - I need to import .csv into specific table called "razpored")


I know this is probably a tough question, but can somebody please help me ?

[Lukael]

Bump, no answer.

Can at least somebody tell me If this is even possible - to export .csv via ODBC in VBA ?

[Marc L]

Hi,

don't know but check on http://www.connectionstrings.com/ …

[Lukael]

Thanks,

I checked, looks like my connection to DB2 is o.k., problem is just that red coloured line of code, for importing .csv to DB2. Got any clues on how to solve that ?

[Lukael]

Problem solved, I just needed to run code from ADMIN_CMD.

For everyone who wiil need this code in future:

Please Login or Register  to view this content.

And be very careful with charachers when writing QUERY commands