Re: RE: Excel File Transfer

["Mike Naughton" <mnaughton@xxxxxxxxxxxx>]

Hi Keith,

Here's a suggestion - maybe your Excel file is not the right version. I
just did the following test on my machine:

1) Downloaded a file from the AS/400 into an Excel spreadsheet. When doing
so, I selected file type BIFF5(MS Excel 5), and I saved the .FDF.

2) Opened the spreadsheet in Excel97, made some changes and saved it. When
asked if I wanted to update to the current version, I said "Yes".

3) Tried to upload the spreadsheet to the AS/400 and got the following
message:"<myfilename> could not be found".

The problem was that I changed the format, and CA no longer recognized the
file. I have used CA to download to and upload from Excel97 many times
over the past several years, and it generally has worked well, but I have
learned that you have to be _very_ sure that you have to keep your
versions straight. CA offers Excel 3, Excel 4, and Excel 5, which are
_not_ the same, and none of them is the same as Excel97. To complicate
things further, I also move the spreadsheets into and out of MS Access,
and it seems to prefer Excel 3. What you need to do is let CA (or Access
or whatever) produce the spreadsheet in whatever version it wants (if
there's a choice, I pick the latest one unless there's a reason not to);
then don't update the format after you've made your changes using Excel97.
Don't ever try to change the format (for example, getting an Excel 3
spreadsheet from MS Access and then saving it as Excel 4 before trying to
upload it

I don't remember if you said that you were getting the new data by
exporting from something else, but if so the following technique worked
for me when I had problems:

1) Download the file from the AS/400 into a new spreadsheet.

2) (optional) If you like, immediately upload it back again, to verify
that you actually can do this.

3) Export the data you want to upload into a second spreadsheet.

4) Copy the data out of the second spreadsheet and paste it into the first
spreadsheet. 

5) Save the first spreadsheet (_DO NOT_ update the file) and close Excel

6) Upload the results

hth

Mike Naughton
Senior Programmer/Analyst
Judd Wire, Inc.
124 Turnpike Road
Turners Falls, MA  01376
413-863-4357 x444
mnaughton@juddwire.com

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---