Ya, I ran into this. My work around was to put the excel file on my computer in the exact same path at the web server.
The web server happened to store the files on the D drive. My D drive was my CD burner. So I burnt the path with Excel file onto a CD and mapped the Excel into the Access file from the CD. Worked great, but it is quite a kludge. :) > -----Original Message----- > From: Claude Schneegans [mailto:[EMAIL PROTECTED] > Sent: Thursday, December 21, 2006 2:20 PM > To: CF-Talk > Subject: Re: upload excel to update database > > >>In MS Access do an external link to an Excel file. > > This could work also, but the problem is that the link is an absolute > path to the file on your disk. > At least, I've never found a way to make it relative to the main > database, then it will not work when you transfer the database on your > server. > > -- > _______________________________________ > REUSE CODE! Use custom tags; > See http://www.contentbox.com/claude/customtags/tagstore.cfm > (Please send any spam to this address: [EMAIL PROTECTED]) > Thanks. > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264830 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
