By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,493 Members | 1,233 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,493 IT Pros & Developers. It's quick & easy.

how to import text field from MySQL db to MS Access 2003 using ImportXML

P: n/a
Hi Guys,

I'm trying to import data out of MySQL db to MS Access 2003 using
ImportXML. I don't have any problems doing the import, except for one
table with a "text" field defined. I'm getting an error message saying
"The field is too small to accept the amount of data you attempted to
add. Try inserting or pasting less data.".

Thanks,

Jan 16 '06 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Do you have to use ImportXML? Why can't you use the ODBC driver to MySQL?

Linda
<ne*******@gmail.com> wrote in message
news:11**********************@g44g2000cwa.googlegr oups.com...
Hi Guys,

I'm trying to import data out of MySQL db to MS Access 2003 using
ImportXML. I don't have any problems doing the import, except for one
table with a "text" field defined. I'm getting an error message saying
"The field is too small to accept the amount of data you attempted to
add. Try inserting or pasting less data.".

Thanks,

Jan 16 '06 #2

P: n/a
MS Access is not allowed to directly access the data from mysql db.
The data from mysql db is exported in xml format using a system (with
user login/password) and then imported into MS Access.

Jan 17 '06 #3

P: n/a
I'm not exactly sure what cosmic events make it work for me, but I do it
all the time. I access tables in a MySQL database using MS Access. I make
edits and run reports.

Linda

<ne*******@gmail.com> wrote in message
news:11**********************@g14g2000cwa.googlegr oups.com...
MS Access is not allowed to directly access the data from mysql db.
The data from mysql db is exported in xml format using a system (with
user login/password) and then imported into MS Access.

Jan 18 '06 #4

P: n/a
When nepifanio says "not allowed" that does not imply "it won't work" but
that a "cautious DBA" or a "cautious IT department" will not _permit_ access
to the MySQL database, but will condescend to export as XML so users won't
be completely isolated from their data.

Larry Linson
Microsoft Access MVP
"Linda Burnside" wrote
I'm not exactly sure what cosmic events make
it work for me, but I do it all the time. I access
tables in a MySQL database using MS Access.
I make edits and run reports. <ne*******@gmail.com> wrote
MS Access is not allowed to directly access
the data from mysql db. The data from mysql
db is exported in xml format using a system
(with user login/password) and then imported
into MS Access.



Jan 21 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.