RE: Excel Spreadsheets to MS Access via CF

2000-12-11 Thread Daryl Fullerton
-Solutions.com [EMAIL PROTECTED] (Chairman) Http://www.cfug.ie The Irish Cold Fusion User Group -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: 11 December 2000 11:29 To: CF-Talk Subject: RE: Excel Spreadsheets to MS Access via CF > Does anyone know the best way to

RE: Excel Spreadsheets to MS Access via CF

2000-12-11 Thread Philip Arnold - ASP
individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** > -Original Message- > From: Daryl Fullerton [mailto:[EMAIL PROTECTED]] > Sent: 10

RE: Excel Spreadsheets to MS Access via CF

2000-12-10 Thread Daryl Fullerton
PROTECTED]] Sent: 10 December 2000 20:04 To: CF-Talk Subject: Re: Excel Spreadsheets to MS Access via CF I have done something similar as follows: export the excel ss to, say a tab delimited file upload the file via an online form or ftp add the data to the database via a CF program which

Re: Excel Spreadsheets to MS Access via CF

2000-12-10 Thread Dick Applebaum
I have done something similar as follows: export the excel ss to, say a tab delimited file upload the file via an online form or ftp add the data to the database via a CF program which: CFHTTP reads the file into a query loops through the above query, issues database insert

Excel Spreadsheets to MS Access via CF

2000-12-10 Thread Daryl Fullerton
Hi, Does anyone know the best way to get the following result. We have an Access Database on the server which collects financial data via online forms. (Datasource 1) This is fine fore some of the clients sales people. How ever some sales people want to be able to upload a standardised Excel s