Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Appending from csv files
Message
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01615469
Message ID:
01615474
Views:
38
Likes (1)
>>>In my directory j:\interlinkhayes are a number of csv files all of the same format delimited with commas
>>>
>>>If I append just 1 file as follows APPEND FROM j:\interlinkhayes\INT12345.csv DELIMITED WITH CHAR , I have no problems
>>>
>>>But if I try APPEND FROM j:\interlinkhayes\INT*.csv DELIMITED WITH CHAR , I get errors
>>>
>>>What is the simplest code for appending multiple files with a skeleton INT*.CSV
>>
>>Hi Colin
>>
>>You could execute a dos command copy *.csv all.csv then append from all.csv.
>>
>>Nick
>
>Thanks - I have a very long winded way of doing it _ I just want the adir solution
>
>But thanks

Running a dos command to copy all the files to one and then importing that is the quickest way you'll do it.
Previous
Reply
Map
View

Click here to load this message in the networking platform