Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel file types?
Greetings all. I am using OPENROWSET in SQL Server 2000 to access an Excel
file in a folder on our server. The file is stored there by any one of several users, and it comes from a report on one of our websites by hitting an export to Excel button. On some users machines, when you hit the button, the file opens up at which point they have to save it from the File menu within Excel, choosing Excel as the file type. When this happens, the file is around 400 KB, and OPENROWSET can access it no problem. However, on some users machines, when they hit the export to Excel button, rather than the file opening, they get a popup asking if they want to open it or save it. If they choose to save it, the normal save as dialog box opens up, and the only options in the file type field are Excel workbook, and all files. Naturally, they choose the Excel option, and hit save. The files that are saved by this method, rather than from the File menu within Excel are around 700 KB, and OPENROWSET can not access them. When I look at the file properties of both files, they appear identical except for the size. The only difference I can find is that if I open the smaller file, the one that was saved from the File menu in Excel, and I choose FileSave as, when the dialog box pops up, the default file type is Microsoft Excel Workbook (*.xls). However, when I open the latter file, the one that was saved from the dialog box that popped up when they hit the export to Excel button, and the one that is 700 KB, and I choose FileSave as, the default file type is Web page (*.htm, *.html), or something like that. If I then choose Excel, and save it, it then becomes the normal 400 KB, and OPENROWSET can access it. Does anyone know what is happening to make the one different? Or what is different about it? or what is making up the extra 300 KB? I am completely flumoxed. Thanks Greg |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I hide unused file types from file types list in save dial | Excel Discussion (Misc queries) | |||
Opening Various File types from an Excel Worksheet | Excel Programming | |||
Excel Viewer 2003 supported file types | Excel Discussion (Misc queries) | |||
Excel 2000 file types have been changing. | Excel Programming | |||
Excel File Types | Excel Discussion (Misc queries) |