answered question
0
Votes
Votes
1
Answer
Answer
M$1.00
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
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
answers (1)
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.
Voted as best: thekid
Hmm gotta try that. Thanks!
Tip sayanosauras for this comment
|
Report
Related questions
140 characters left
ask any question
