Real Software Forums

The forum for Real Studio and other Real Software products.
[ REAL Software Website | Board Index ]
It is currently Wed Nov 14, 2018 11:17 am
xojo

All times are UTC - 5 hours




Post new topic Reply to topic  [ 3 posts ] 
Author Message
 Post subject: Best way to transfer data excel to SQL
PostPosted: Wed Mar 27, 2013 4:39 pm 
Offline

Joined: Sat Mar 15, 2008 8:14 am
Posts: 161
Location: Montreal, Quebec, Canada
Hi everybody
I re-post the same question as before with more details ( I hope get a answer )
I search for the best way to transfer a lot of data from excel to MSSQL
I use MBSxl plugin to read my excel
I put the header in a listbox to modify it then initialize my SQL DB Table with the new header
From there what is the best way to transfer the rest of excel to my new SQL DB
I'm able to fill up my listbox with all my data
should i transfer to SQL Cell by cell ?
OR can i pass data directly to DB without listbox by an array
Can i pass data by an array even not knowing the type of data
can i use multi-dimension array to reduce transaction to DB

You see!!! i need advice
Thanks

_________________
--------------------
RB 2011r4 on win7


Top
 Profile  
Reply with quote  
 Post subject: Re: Best way to transfer data excel to SQL
PostPosted: Thu Mar 28, 2013 11:51 am 
Offline
User avatar

Joined: Wed Sep 20, 2006 5:12 pm
Posts: 680
Location: Puerto Rico
Make a map in string for each columns with the name of Db fields and then insert the record to db

_________________
Thanks for any contribution and God blesses all (I start Using RS in 10/12/2010)
Mac Mini with Lion v10.7.5 and Real Studio 2012r1 Pro And Windows 7 RS2012r1 Personal and Linux RS2012r1 Personal Register user
my Hobbies R/C Turbines Jets Models


Top
 Profile  
Reply with quote  
 Post subject: Re: Best way to transfer data excel to SQL
PostPosted: Thu Mar 28, 2013 12:13 pm 
Offline

Joined: Sat Mar 15, 2008 8:14 am
Posts: 161
Location: Montreal, Quebec, Canada
thanks for the reply... but it a little too vague for a newbie
i doubt i can query a column trough the MBSxl plug in
do i have to fill up my listbox or an array before

_________________
--------------------
RB 2011r4 on win7


Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 3 posts ] 

All times are UTC - 5 hours


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
Jump to:  
cron
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group