Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

access to mysql datatype

Status
Not open for further replies.
piper3d

piper3d

Technical User
Aug 8, 2002
6
US
I am exporting an access 2000 database to mysql through odbc.

Everything exports ok.

If I then link the mysql database from access 2000 through odbc, the data type is memo, it was originally text.

The original datatype in the access 2000 database is text.

Why is mysql changing the data type to memo?

How can I link it back in to access 2000 and have the datatype as text and not memo?

Thank You In Advance,
Brian Weber
 
Sort by date Sort by votes
Does the same for me, although its set as text. I just left it there shouldnt be a problem with that.
www.vzio.com
star.gif
/ [wink]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

E
  • Locked
  • Question
MySQL calculator tools
Replies
0
Views
223
EdZzy
E
lupidol
  • Locked
  • Question
Cannot create new table in mySQL 3
Replies
6
Views
439
lupidol
lupidol
lupidol
  • Locked
  • Question
mysql cannot add rows with "UNION" 1
Replies
5
Views
398
Chris Miller
Chris Miller
dylim
  • Locked
  • Question
Why MySQL 5.7 is still getting updates
Replies
3
Views
331
spamjim
spamjim
dylim
  • Locked
  • Question
SQL_CALC_FOUND_ROWS still runs in MySQL 8.0.29
Replies
2
Views
473
dylim
dylim

Part and Inventory Search

Sponsor

Back
Top