# Transferring a table from SQL Server 2k5 to KDB+

**URL:** https://forum.kx.com/t/transferring-a-table-from-sql-server-2k5-to-kdb/6050
**Category:** Community Support
**Tags:** kdb-and-q
**Created:** [April 29, 2009, 2:32pm UTC](https://forum.kx.com/t/transferring-a-table-from-sql-server-2k5-to-kdb/6050 "2009-04-29T14:32:00Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![sayandeep52](https://avatars.discourse-cdn.com/v4/letter/s/ecae2f/32.png) [@sayandeep52](https://forum.kx.com/u/sayandeep52)
#### Post date: [April 29, 2009, 2:32pm UTC](https://forum.kx.com/t/transferring-a-table-from-sql-server-2k5-to-kdb/6050/1 "2009-04-29T14:32:00Z")

</div>

Hi,I already saw a post discussing the same, but the content seemed a bitdelphic to me, so this post. I have the file odbc.k and have saved itto W32, now my question is how to use it in data transfer from SQLServer to kdb+.(From the documentation) This is not working for me…\>q w32/odbc.kq).odbc.load`northwind.mdb / will load entire databasePlus I have got the following syntactical questions about odbc.k:1. What is the syntax to copy a database from a remote location intokdb+?2. How to copy specific tables from a database in kdb+?By database I mean SQL Server 2k5.Thanks,Sayan