I have been assigned to a new project that has two applications. One of the applications is a MS Access file that people carry on their laptop. They use MS Access because the users work in a lot of places where they have no access to the Internet. When they are done using the MS Access application the user has to go to a location with Internet access, export the data in one of the MS Access tables to an Excel file, which then gets uploaded to a website.
Here are the steps the data goes through. 1) While in MS Access the user exports the table's data to an Excel file. 2) The user goes to the website to select the Excel file created by MS Access using an HTML file select form field. (The name of the Excel file is usually always different, but the table inside the file and its format are always the same.) 3) When the user clicks the submit button the selected Excel file is uploaded to the server. 4) The site uses cfspreadsheet to read the data from the Excel file 5) The site uses SQL code to insert the data into the site's SQL database. 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.) If it helps, we can use the following names: MS Access file = MyAccessFile MS Access table = MyAccessTable SQL Server database = MySqlDatabase SQL Server table = MySqlTable The columns in the table can be: GizmoName = Varchar (255) GizmoDescription = Text ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:352125 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
