EASY EXCEL AUTOMATION

[Guest.Visitor]

I downloaded this from Midrange and would like to use it, but as I can't remember when it was, I can not find any information about it nore any way to use it. This tips normally permits, as I can see, to make some file transfers from AS/400 with SQL selection (but behind this, it looks like Visual Basic instructions), and it could be what I'm actually need. Does anyone use this trick, if yes, could you remember me if the description was anywhere in the forums or just something published in Midrange Magazine so I could try to understand the way it will work. thanks in advance

[Guest.Visitor]

Rene, Yes, you could transfer data from the 400 using an OLE/DB recordset or other connection in the VBA code section, but I would recommend an easier course to take. Use Microsoft Query to download. It is an optional installation program off of your Office CD. It is then accessible via the Data/External Data/Create New Query. An ODBC data source is necessary for this to work, and it will allow you to create it at query creation time if one is not already created. Bill

[Guest.Visitor]

Do you know where I can find any tips/tricks on uploading Excel data to teh AS400? Mike Wilson

[Guest.Visitor]

Mike, I don't upload from Excel, I upload from Visual FoxPro. I would suggest the easiest way to do it would be to create either a comma-delimited or fixed length record exported from your data. Then upload this to the 400 and parse the data from there. You probably could do what someone else suggested in another thread and that would be to cycle through the cells loading the values into the 400 table's fields and performing an SQL Insert, but since I haven't done that, I can't really help you with it. Bill