Databases :: MySql :: how to read a mysql file on MS SQL server |
|||
By: Squibi  |
Date: 10/02/2003 00:00:00  |
Points: 50 | Status: Answered Quality : Excellent |
|
I have a Mysql database. I want to use VB to export this database to a file, which can read by sql server . However, I don't want to use any software to convert it. I want to hard code it. What can I do? Thanks very much for any help in advance. |
|||
| By: VGR | Date: 10/02/2003 10:20:00 | |
Type : Answer |
| easy look doc at <A HREF="http://www.mysql.net">www.mysql.net</A> and search for keyword "OUTFILE" stemanet to execute is SELECT * FROM tablename INTO OUTFILE 'output.txt' SEPARATED BY ... DELIMITED BY... TERMINATED BY... (as you wish) Look the documentation page on this, you'll find the thing you need : the statement to generate a CSV file ;-)) CSV is directly importable in all Macro$ux products, from eXcel to Access via Word and - why not ? - MS-SqlServer have fun |
|||
|
Do register to be able to answer |
|||
©2010 These pages are served without commercial sponsorship. (No popup ads, etc...). Bandwidth abuse increases hosting cost forcing sponsorship or shutdown. This server aggressively defends against automated copying for any reason including offline viewing, duplication, etc... Please respect this requirement and DO NOT RIP THIS SITE.
Please DO link to this page!
Contact
- Privacy
- Contact us
- Member Agreement
- Jobs for our Experts
- our friend ActuLab
- Carcasherdotcom Seocontest
- Add Your Link
- Bee Web Directory
- Discover Directory
- FFind Directory
- Link Velocity Directory
- The Little Web Directory
- Red Links
- Tranix
- 2space Global Directory
Fully downloaded more than 1313 Million times
Copyright © 2003 - 2012 The IT European Experts Organization
last update on : 23/07/2008 09:41:27 GMT 0 (CEST)
