There are a lot of ways to get data from MSAccess to a SQL database. However, even though this seems cumbersome, it is an effective method, the users know how to do it, and the excel import and export tools are solid. I would leave it alone. It it ain't broke....
On Mon, Aug 13, 2012 at 7:38 AM, ib webn65 <[email protected]> wrote: This seems cumbersome. I was wondering if there was a way to get the data > directly from the MS Access file and insert it into the SQL database table? > The name of the MS Access file will change, but the format of the table in > the MS Access file will never change. (I know, never say never. But for the > purpose of this question, let's stick with saying never.) > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:352259 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
