Hello cf-talk, I have an oracle database on a client's host, but not direct access to it. The table is set up to accept dealer information, simple fields of name, address, web, email. I have an Excel spreadsheet with all the dealer info. The database admin guy wants me to get the info into the oracle table without his help (he won't use SQL Loader or whatever its called). So, anyideas as to the best way to get my data in there? I have about 500 records. I was going to make a query from a local datasourse that would populate a form, that would send to a insert.cfm page on the remote server, populating the remote table. There has to be a better way! Best regards, Jeff Fongemie mailto:[EMAIL PROTECTED] ------------------------ Internet Guns For Hire (603) 356-0768 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
