Hi All,
I am working on VB and Access. What I need to do is I wnat to migrate to MySql with all data as it is from Access.
I know we can do it by many ways, but I preffer by Exporting data from Access in CSV format and importing that in MySql.
Can you help me out doing the same.
Some kind of code or URL's will be more usefull.
Thanx :-)
Thread: MySQL and VB
-
No Profile PictureJunior MemberDevshed Newbie (0 - 499 posts)
- Join Date
- Nov 2002
- Location
- Mumbai
- Posts
- 2
- Rep Power
- 0
MySQL and VB
-
/(bb|[^b]{2})/
- Join Date
- Nov 2001
- Location
- Somewhere in the great unknown
- Posts
- 5,163
- Rep Power
- 796
What are you wanting help with?
-
No Profile PictureJunior MemberDevshed Newbie (0 - 499 posts)
- Join Date
- Nov 2002
- Location
- Mumbai
- Posts
- 2
- Rep Power
- 0
I want to know how to import CSV file(filled with data of access) from MySql and dump all data directly in tables(similar to access).
-
/(bb|[^b]{2})/
- Join Date
- Nov 2001
- Location
- Somewhere in the great unknown
- Posts
- 5,163
- Rep Power
- 796
See the mysql manual:
http://www.mysql.com/doc/en/LOAD_DATA.html -
No Profile PictureContributing UserDevshed Newbie (0 - 499 posts)
- Join Date
- Nov 2001
- Location
- USA
- Posts
- 313
- Rep Power
- 22
I have some code you can take a look at here..
mySQL and VB6 Code
.NET and mySQL
It may help you out.
November 14th, 2002, 03:10 AM
Reply With Quote
November 14th, 2002, 08:26 AM
November 14th, 2002, 08:49 AM
November 14th, 2002, 09:42 AM
November 18th, 2002, 12:38 PM
