HomeForum
Welcome, Guest

How do I export from a sql table to a csv
(1 viewing) (1) Guest
  • Page:
  • 1

TOPIC: How do I export from a sql table to a csv

How do I export from a sql table to a csv 10 months, 2 weeks ago #3075

  • Scott
  • OFFLINE
  • Junior Boarder
  • Posts: 24
  • Karma: 0
How do I export from a sql table to a csv.
I don't need any processing, just a dump of all fields and all rows.

Regards,
Scott

Re: How do I export from a sql table to a csv 10 months, 2 weeks ago #3076

  • admin
  • OFFLINE
  • Moderator
  • Posts: 2182
  • Karma: 12
Hi.

If it is once-off have a look at Data Exchange wizard.
Trials is fully functional for 30 days so it will cost you nothing
www.dbsoftlab.com/ETL-Tools/Data-Exchange-Wizard.html

If you want to do automate it have a look visual importer pro
www.dbsoftlab.com/ETL-Tools/Visual-Importer-Professional.html

Mike
DB Software Laboratory

Re: How do I export from a sql table to a csv 10 months, 2 weeks ago #3077

  • Scott
  • OFFLINE
  • Junior Boarder
  • Posts: 24
  • Karma: 0
I have visual importer enterprise but I am not sure how to do this export. I've done lots of progress to sql and sql to sql but no sql to csv.
Regards,
Scott

Re: How do I export from a sql table to a csv 10 months, 2 weeks ago #3078

  • admin
  • OFFLINE
  • Moderator
  • Posts: 2182
  • Karma: 12
OK
I see it is simple see attached screen-shots

Create connection for data source
Create directory to export data to
Click new Export
Define all parameters
Create new package
Add export to the package
Run package

Mike
Attachments:
  • Page:
  • 1
Time to create page: 0.25 seconds

Testimonials

"Pricing is an important aspect of our software investment program and DBSL exceeded our expectations in both performance and value for money."

Dana Sander,
ICT Manager

User Login

You only need to log in or register to use our support forum



Our customers

BP

BBC

HSBC


Databases we work with

Go to top