If you have no gaps in the autoid field in Access, you can create am additional field in MySQL for your Access ID, and order the Access table in ID order, then import it and the MYSQL autonumber field should match the Access ID field. if that is the case, you can then delete the extra field.
If you have gaps and id is an essential data element that has relational children, it's a much more complex problem. If that is the case, let me know and I'll try to explain how to do it. On Tue, Apr 19, 2011 at 10:46 PM, Scott Williams <[email protected]> wrote: > > Oy -- I shouldn't have started this one until the weekend. > > I'm converting from MS Access to MySQL on one of my ColdFusion sites, and > having problems converting my Autonumbered Access tables to MySQL format. > They just won't import at all. If I remove the primary key and change the > format to Integer instead of Autonumber, the tables import. > > The real problem is when I try to add data to these tables later. It will > take one additional record (numbering it 0), then won't take anymore because > then there would be two 0s. > > How can I get a MySQL table to autonumber like Access? > > Scott ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343862 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
