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


> >
> > In your structure, for example, npa is defined as char(3) but in data file line I see it as 5 characters. You would need to remove quotes to make the size match. Here is a SQL bulk insert sample:
> >
> > https://www.foxite.com/archives/0000301912.htm
> >
> > Cetin Basoz
> >
> > .Net has got better.Think about moving - check my blog:
> > My Blog
> > Blog (mirror) - sounds to be down
>
> 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 to 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:

https://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

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