Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Appending from a csv file
Message
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Appending from a csv file
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 10
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01624860
Message ID:
01624860
Views:
69
Morning

Start of week and I have forgotten how to append data in CSV format into an existing table

My Code


USE j:\global\awbshayes IN 0 EXCLUSIVE
SELECT awbshayes
Append From j:\global\awbshayes.csv DELIMITED WITH '"' WITH CHAR '"

Doesn't work

Text is in double quotes , fields are comma delimited

Quick help would be appreciated
Specialist in Advertising, Marketing, especially Direct Marketing

I run courses in Business Management and Marketing
Next
Reply
Map
View

Click here to load this message in the networking platform