Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Yehuda Epstein
  Where is Yehuda Epstein?
 Monsey
 New York - United States
 Yehuda Epstein
 To: Cetin Basoz
  Where is Cetin Basoz?
 Izmir
 Turkey
 Cetin Basoz
 Tags
Subject: RE: SQL server importing from a deli file
Thread ID: 311102 Message ID: 311194 # Views: 23 # Ratings: 0
Version: Visual FoxPro 6 Category: Databases, Tables and SQL Server
Date: Wednesday, June 29, 2011 3:34:47 PM         
   


> >
> > Thanks a lot. I see already that it works just by adding
DATAFILETYPE = 'char',

> > to the SQL code after creating the txt file. I am aware of the fact
> > that the code will import up to 1000 rows. Will I have the same problem > > with using the code you sent me in VFP?
> In any case I thank you,

> > Yehuda.
>
> Up to 1000 rows? I wasn't aware of such a limitation. But anyway for
> anything above 1000 rows I use this one myself:
>
> http://www.foxite.com/archives/cursor-adapter-0000207817.htm
>
> Cetin Basoz
>
> .Net has got better.Think about moving - check my blog:
> My Blog
> Blog (mirror) - sounds to be down

Sorry,
I queried by left click on the table in SQL and chose top 1000. I went through the code and it has a lot of elements I will need to use in the future.
Thanks again,
Yehuda.

ENTIRE THREAD

SQL server importing from a deli file Posted by Yehuda Epstein @ 6/28/2011 9:24:44 PM
RE: SQL server importing from a deli file Posted by Cetin Basoz @ 6/28/2011 10:49:23 PM
RE: SQL server importing from a deli file Posted by Yehuda Epstein @ 6/28/2011 11:32:49 PM
RE: SQL server importing from a deli file Posted by Cetin Basoz @ 6/29/2011 12:46:31 PM
RE: SQL server importing from a deli file Posted by Yehuda Epstein @ 6/29/2011 3:34:47 PM