Many thanks Charlie. I just got in the office and read this. Honestly I have been out of the ACFUG loop for a bit and completely forgot about these resources. So I will give this some loving :-) ...
My other thought would be ask if you think it would be ok to just use the files themselves as the database rather than import and use MS SQL. This way the files could just be uploaded to the server and overwritten when they need to be updated. There are basically 5 files with some location data in it that are used for a specialized dealer locator app. My thought was maybe I could just read the files into a select query and then loop the query to filter the records to be displayed. There will never be more than several hundred records in the excel files. However the site that will use it may have a fair amount of traffic so I didn't know if reading the files might become a problem. Perhaps I could read them into a cached query to solve that problem? Does anyone see any reason why this approach would not work? Dusty On Fri, Mar 6, 2009 at 4:23 PM, Charlie Arehart <[email protected]>wrote: > No love from anyone for CF411. :-( How can I get people to say, whenever > anyone asks “what tools are there to do xyz”, to tell them to check out > cf411.com. I’m not selling anything there. :-) It exists precisely to help > with these questions. > > > > Dusty, check out: > > > > Excel File Processing Tools > > http://www.cf411.com/#excel > > > > for several different kinds and dozens of different resources for doing > CF/Excel processing, in both directions. > > > > I realize you may wonder if I can say which of these many excel approaches > would be best for what you need, but I’m afraid I can’t vouch for any. With > 700+ tools/resources on the list (in 125+ categories), I really can’t use > them all. But I do offer brief descriptions and links, which should help you > consider the options. (I also did an article presenting this info in the > last FAQU, in my back page column, if you have that.) > > > > Hope that’s helpful. > > > > /charlie > > > > *From:* [email protected] [mailto:[email protected]] *On Behalf Of *Dusty Hale > *Sent:* Friday, March 06, 2009 9:31 AM > *To:* [email protected] > *Subject:* [ACFUG Discuss] excel or csv to database table > > > > Hi I need to implement some CF code that does this and before I write all > the code, I thought certainly there has got to be a custom tag or cfc that > already does this: > > > 1. Upload excel or csv file to server. > 2. Import the excel sheet or csv file into a database table. > > I found an upload custom tag and now I am looking for any advise or > recommendation on a custom tag or cfc or piece of code that will handle the > import part. If anyone knows of a good solution for this, please share. Much > appreciation! > > Thanks, > > Dusty > > ------------------------------------------------------------- > To unsubscribe from this list, manage your profile @ > http://www.acfug.org?fa=login.edituserform > > For more info, see http://www.acfug.org/mailinglists > Archive @ http://www.mail-archive.com/discussion%40acfug.org/ > List hosted by FusionLink <http://www.fusionlink.com> > ------------------------------------------------------------- -- Dusty Hale Website: www.DustyHale.com Email: [email protected] Phone (Atlanta): 404.474.3754
