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]



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