Re: Web Based Spreadsheet To MSSQL Mapping

2005-03-03 Thread Claude Schneegans
>>It would be the reading in the Excel file and grabbing the data correctly. But isn't this supposed to be handled by the ODBC driver? Sure the Excel file may contain things not compatible with the database, but I assume that if the driver cannot get it, I don't see what I could do any better r

Re: Web Based Spreadsheet To MSSQL Mapping

2005-03-03 Thread Aaron Rouse
To me the mapping itself would not be the nightmare. It would be the reading in the Excel file and grabbing the data correctly. Dealing with any "pretty" formating it might have, dealing with multiple worksheets and so on. I actually have the need for something kind of like this and will be tack

Re: Web Based Spreadsheet To MSSQL Mapping

2005-03-03 Thread Claude Schneegans
>>A matching tool as described would be an easy sell to a lot of people. Ah ah! A great idea for a new tag? ;-) >> Though probably would be a nightmare to try Not really, using CFX_ODBCInfo would make it pretty easy. I'm about to release a super new application: The ODBCMyAdmin, version 1.0 an

RE: Web Based Spreadsheet To MSSQL Mapping

2005-03-03 Thread Bryan F. Hogan
Ah, and that's why I don't want to write it myself. I was thinking something along the lines of a mail merge. -Original Message- From: Aaron Rouse [mailto:[EMAIL PROTECTED] Sent: Thursday, March 03, 2005 11:42 AM To: CF-Talk Subject: Re: Web Based Spreadsheet To MSSQL Mapping

Re: Web Based Spreadsheet To MSSQL Mapping

2005-03-03 Thread Aaron Rouse
A matching tool as described would be an easy sell to a lot of people. Though probably would be a nightmare to try and make which might be why I have never stumbled upon a "canned" solution for it. :) On Thu, 03 Mar 2005 11:38:18 -0500, Claude Schneegans <[EMAIL PROTECTED]> wrote: > >>If you ha

Re: Web Based Spreadsheet To MSSQL Mapping

2005-03-03 Thread Claude Schneegans
>>If you haven't seen one that's ok. But I don't want to speak about the reason I want to do this. I was just joking ;-) The reason I asked is because I have a site in which spreadsheets are imported, but the columns always match, so it won't help. I don't know about any matching tool however

RE: Web Based Spreadsheet To MSSQL Mapping

2005-03-03 Thread Dawson, Michael
might not work as well. M!ke -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED] Sent: Thursday, March 03, 2005 10:24 AM To: CF-Talk Subject: RE: Web Based Spreadsheet To MSSQL Mapping Ok, let me reiterate. I care for them because I know if they can see an example, they

RE: Web Based Spreadsheet To MSSQL Mapping

2005-03-03 Thread Bryan F. Hogan
D] Sent: Thursday, March 03, 2005 11:11 AM To: CF-Talk Subject: Re: Web Based Spreadsheet To MSSQL Mapping >>Against all of my recommendations to have us write an import >>function they don't want to spend the money. Well, if they don't want to spend the money, why care for

Re: Web Based Spreadsheet To MSSQL Mapping

2005-03-03 Thread Claude Schneegans
>>Against all of my recommendations to have us write an import >>function they don't want to spend the money. Well, if they don't want to spend the money, why care for them anyway? ;-) Do I understand well that if spreadsheets come from their client, they can have about anything in it, in any f

RE: Web Based Spreadsheet To MSSQL Mapping

2005-03-03 Thread Bryan F. Hogan
at this has not been done before and that no one on this list hasn't seen one before. Thanks for your reply -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED] Sent: Thursday, March 03, 2005 10:36 AM To: CF-Talk Subject: Re: Web Based Spreadsheet To MSSQL Mapping On F

Re: Web Based Spreadsheet To MSSQL Mapping

2005-03-03 Thread Thomas Chiverton
On Friday 25 Feb 2005 15:21 pm, Bryan F. Hogan wrote: > send it to me. Against all of my recommendations to have us write an import > function they don't want to spend the money. So, fine. Let them do it that way. When it breaks, explain why. -- Tom Chiverton Advanced ColdFusion Programmer ~~

Web Based Spreadsheet To MSSQL Mapping

2005-02-25 Thread Bryan F. Hogan
I have a client that collects spreadsheets created by their client. They then format the spreadsheet to match the table on their Intranet and then send it to me. Against all of my recommendations to have us write an import function they don't want to spend the money. I'm concerned that it will slo