Answered Question

sayanosau...

M$1.00 Funded By Mahalo ? | April 30, 2009 01:50 PM

I am unable to load an mdb file from sql server 2k5 to kdb+. Heeeeelp!

Hi,

I have consulted the documentation and tried out the syntax given on q for mortals, but it doesn't work.

I have the file odbc.k and have saved it at W32, now my question is how to use it in data transfer from SQL Server to kdb+.

(From the documentation) This is not working for me...

>q w32/odbc.k

q).odbc.load`northwind.mdb / will load entire database

Plus I have got the following syntactical questions about odbc.k:

1. What is the syntax to copy a database from a remote location into
kdb+?
2. How to copy specific tables from a database in kdb+?

Anyone providing pointers to people who are experts and could help would be great for me.

Thanks,
Sayan

Interesting Question? Yes (0) No (0)

RSS

Best Answer Decided by Votes

pvera

April 30, 2009 02:18 PM

Can't you use Data Transformation Services in SQL and connect to kdb+ through ODBC? This should allow you to move all of your data out of SQL Server.

Helpful Answer?

(0)

(0) Tip pvera for this answer

Permalink | Report

Voted as best: thekid

sayanosaur...

May 04, 2009 07:52 PM

Hmm gotta try that. Thanks!

Tip sayanosauras for this comment

Report

Answer this Question

Ask a Question

Top of Page

Buy Mahalo Dollars with Credit Card or PayPal

Top Members

This Week All Time

cfinke
2nd Degree Black Belt
27126 Points
M$29.75 Earned
bunnyphuph...
2nd Degree Black Belt
21128 Points
M$760.89 Earned
thisjustme
Green Belt
1155 Points
M$76.30 Earned

See All

Most Popular Tags

mahalo(1779)

twitter(972)

music(494)

iphone(485)

google(390)

online(360)

food(339)

internet(309)

beer(284)

money(283)

movies(278)

facebook(270)

apple(259)

answers(241)

aotd(235)

free(232)

health(228)

video(222)

dog(212)

windows(211)

See All

Welcome New Members

clarkies6, December 10, 2009 10:08 AM
rony1434, December 10, 2009 10:08 AM
cld, December 10, 2009 10:06 AM
poolwoker, December 10, 2009 10:05 AM
rokini, December 10, 2009 09:56 AM

Mahalo Dollars are the currency of Mahalo Answers.

Each Mahalo Dollar costs $1.

Once you earn more than 40 Mahalo Dollars, you can request to be paid via PayPal. Each Mahalo Dollar is currently worth $0.75 when paid out via PayPal. Learn More