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!

Import from Access xp

Status
Not open for further replies.
Guest_imported

Guest_imported

New member
Jan 1, 1970
0
When I import from *.mdb the data fields come in as 0, 255, or other numbers

Error: 1064 - You have an error in your SQL syntax near 'UNSIGNED NOT NULL, LastName LONGTEXT UNSIGNED NOT NULL, CosID LONGTEXT UNSIGNED ' at line 1


What did I do wrong?
 
Sort by date Sort by votes
MySQL CrashMe has a list of incompatible features and datatypes for many databses

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

penguinspeaks
  • Locked
  • Question
Update column based on input from another column 3
Replies
6
Views
404
penguinspeaks
penguinspeaks
PeDa
  • Locked
  • Question
Opening MySQL table from Microsoft Access
Replies
1
Views
186
PeDa
PeDa
wilsjay22
  • Locked
  • Question
Freeing up disk space from information_schema
Replies
1
Views
315
jg2828
jg2828
eizs002
  • Locked
  • Question
Connect MS Access to mysqlDB without ODBC
Replies
3
Views
299
spamjim
spamjim
AbidingDude
  • Locked
  • Question
Loading From A CSV File
Replies
2
Views
176
AbidingDude
AbidingDude

Part and Inventory Search

Sponsor

Back
Top