On 6/23/06, Graham Bish <[EMAIL PROTECTED]> wrote:
Hi fellow MapInfo users
I am trying to build a .WOR File to DBMS a series of tables out of a Ms
Access database.
Below is the MapBasic script that is displayed in the MapBasic window in
MapInfo V8 (but it doesn't work when placed in a workspace)
Below is the code that I use to open a MS SQL Server table. Check the
MB help file for the proper connection string for anMS Access db.
dim con as integer
con=Server_Connect("ODBC", "DSN=database;UID=user_name;PWD=password")
server con link table "select * from remote_table" into local_table
Rich
--
Richard Greenwood
[EMAIL PROTECTED]
www.greenwoodmap.com
_______________________________________________
MapInfo-L mailing list
[email protected]
http://www.directionsmag.com/mailman/listinfo/mapinfo-l
