MI - Sending data to an ODBC database

2000-05-10 Thread Graham Smith




Dear all,

I may be missing something very simple here, but is there a way to 
'reverse-link' a MapInfo table into an ODBC database?

What I mean by that is - instead of linking a table from an ODBC 
source into MapInfo, I want to read a native (not linked) MapInfo table into 
an ODBC database (the db is Access97)

The table is a table of retail outlets, and I want to automate the process 
of populating a table of retailer information, from within my MapInfo 
application, into the Access database

All I can think of is to loop through the MI table creating temporary 
variables, and use these to send an insert command to the ODBC database for each 
record - very time consuming for 50,000 records. Any pointers more than 
welcome.

Cheers 
Graham 
Smith


Re: MI - Sending data to an ODBC database

2000-05-10 Thread Colonel Erick Posner


You could use, "EasyLoader.mbx" to upload the table into the ODBC.

It's under the "Tools".



On Thu, 11 May 2000, Graham Smith wrote:

 Dear all,
 
 I may be missing something very simple here, but is there a way to
 'reverse-link' a MapInfo table into an ODBC database? 
 
 What I mean by that is - instead of linking a table from an ODBC source
 into MapInfo, I want to read a native (not linked) MapInfo table into an
 ODBC database (the db is Access97) 
 
 The table is a table of retail outlets, and I want to automate the
 process of populating a table of retailer information, from within my
 MapInfo application, into the Access database
 
 All I can think of is to loop through the MI table creating temporary
 variables, and use these to send an insert command to the ODBC database
 for each record - very time consuming for 50,000 records. Any pointers
 more than welcome. 
 
 Cheers Graham Smith
  
 
  
 

-
   Erick Posner
-
Earn $$ while surfing on the website! 
http://www.alladvantage.com/go.asp?refid=cbl286

-
"My Mom said she learned how to swim.  Someone took her out in the lake
and threw her off the boat.  That's how she learned how to swim.  I said,
'Mom, they weren't trying to teach you how to swim.' "
 --Paula Poundstone 


--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]