New topic: Best way to transfer data excel to SQL
<http://forums.realsoftware.com/viewtopic.php?t=47422> Page 1 of 1 [ 3 posts ] Previous topic | Next topic Author Message Dralion Post subject: Best way to transfer data excel to SQLPosted: Wed Mar 27, 2013 4:39 pm Joined: Sat Mar 15, 2008 8:14 am Posts: 152 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 jetpr Post subject: Re: Best way to transfer data excel to SQLPosted: Thu Mar 28, 2013 11:51 am Joined: Wed Sep 20, 2006 5:12 pm Posts: 626 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 Dralion Post subject: Re: Best way to transfer data excel to SQLPosted: Thu Mar 28, 2013 12:13 pm Joined: Sat Mar 15, 2008 8:14 am Posts: 152 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 Display posts from previous: All posts1 day7 days2 weeks1 month3 months6 months1 year Sort by AuthorPost timeSubject AscendingDescending Page 1 of 1 [ 3 posts ] -- Over 1500 classes with 29000 functions in one REALbasic plug-in collection. The Monkeybread Software Realbasic Plugin v9.3. http://www.monkeybreadsoftware.de/realbasic/plugins.shtml [email protected]
