Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: xtian nojimas
  Where is xtian nojimas?
 General Santos City
 Philippines
 xtian nojimas
 To: Andy Kramek
  Where is Andy Kramek?
 Hot Springs Village
 Arkansas - United States
 Andy Kramek
 Tags
Subject: RE: insert into
Thread ID: 111993 Message ID: 112204 # Views: 3 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Monday, November 06, 2006 2:47:04 AM         
   


Thank you for the info sir I'll also try it via xml.

> > Hello experts,
> >
> > Pls. Help me with this problem.
> > I have a result from a local table query and I put it to a cursor. I want it to insert to a table in the SQL Server Database.
> >
> > I don't want to loop from the top to the bottom of the cursor to insert every record. Is there a way to do it.
> >
> > Thanks in advance.
> >
> > xtian
> > LIFE is LOGICAL there is always TRUE .or. FALSE .and. IF...THEN... ELSE... :p

>
> If you are asking is there a bulk insert option from VFP to SQL Server, the answer is NO.
>
> You have only two options that I know of.
>
> First export the data to a text file, and use the BCP utility to load it into SQL Server.
>
> Second, create a DTS Package and run that from VFP.
>
> Otherwise a loop-through and insert is the only way to do it.
>
> (Just another difference between a set-oriented database like SQL Server, and a record-oriented database like VFP).
>
> Regards
> Andy Kramek
> Microsoft MVP (Visual FoxPro)
> Tightline Computers Inc, Akron Ohio, USA




LIFE is LOGICAL there is always TRUE .or. FALSE .and. IF...THEN... ELSE... :p

ENTIRE THREAD

insert into Posted by xtian nojimas @ 11/3/2006 9:26:08 AM
RE: insert into Posted by Andy Kramek @ 11/3/2006 1:16:09 PM
RE: insert into Posted by xtian nojimas @ 11/6/2006 2:47:04 AM
RE: insert into Posted by Andy Kramek @ 11/6/2006 1:04:27 PM
RE: insert into Posted by Noker Lodia @ 11/4/2006 12:28:25 PM