Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Import SQL Server query into a DBF
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01672529
Message ID:
01672537
Views:
51
>Hi,
>
>When you run a SQL Select in SSMS and see the query, you can Select All and Copy with Header or Without Headers.
>But then, if you paste this "report" into a Word or Notepad, you can't really see the records easily.
>
>Has anybody created a code that would import this copy of the SQL Server query into a DBF?
>
>TIA

The query results are either Tab Delimited or CSV. If you copy you can use `Save As...` then save to CSV. If you have FoxPro (or a FoxPro application) you can import the CSV and turn it into a DBF.
+++ Rick ---

West Wind Technologies
Maui, Hawaii

west-wind.com/
West Wind Message Board
Rick's Web Log
Markdown Monster
---
Making waves on the Web

Where do you want to surf today?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform