On Fri, 12 Feb 2010 14:34:03 -0800, George
wrote:

Daniel - I understand you can't use Access to create a web database, but I
noticed on my host provider has a feature to upload a Access database and
covert it to SQL rather then creating a table within their SQL from scratch,
does that sound possible ?

MySQL and Microsoft SQL/Server are two *different programs* (competitors, in
fact). Don't confuse them with one another!

But yes, it's possible to upsize an Access database to either. Not trivial but
possible. I'd be inclined to learn enough MySQL (if that's what your provider
supports) to create the table, properly normalized with indexes and so on; you
will then be able to use an ODBC connection from your Access database to your
new MySQL database, and run Append queries to migrate your data into MySQL. If
you are working with SQL/Server there are Microsoft upsizing tools to do so -
take a look in the microsoft.public.access.sqlupsizing newsgroup for detailed
discussions.
--

John W. Vinson [MVP]