Search results for query: *

I am using a vendor supplied access database to upload price sheets into our AS/400. On the query, I need to change the preset quantity to accept alpha instead of numerical data. The query is set up to use the imported excel database and plug the information into a form that is readily...

Hi Chris, What I did was to create a macro and under actions, type TransferSpreadsheet. For the action arguments, select import as the transfer type, and for the file name, use the path and name for where your file is located.

Thanks for your help Terry. I just took your advice and ran the select portion. That came out exactly the way I wanted it to. I am not getting any errors when I run the query. This is really starting to drive me bonkers. I really don't know what to do next.

The following is a query that I am trying to run. It runs without any errors, but the data in the table does not get updated. Any clues as to what I am doing wrong? PARAMETERS PDate DateTime; INSERT INTO [New Pricing] ( ManufacturerCode, Standard_Pack, [Date], Quantity_1, DistCost_1...

That is exactly what I'm trying to do. I've done it before with no problems, but this time it keeps on importing the incorrect data. I checked my excel spreadsheet and it looks fine. I modified the original workbook by deleting three of the sheets and deleting the column headings. Thank you...

I have an excel spreadsheet which I modified and renamed. Everytime I try to import the spreadsheet, I always get the original one even if I click on the modified one. I tried deleting the original spreadsheet, but that didn't work. When I open the modified spreadsheet, the data looks exactly...