Search results for query: *

Update: it is working - I put a key on the field which needs to repeat. I also just made a simple append query connecting the split table to the origin table and append all additional fields to a final table. For real this time .... my last item to address is to prorate the charge amount...

Ok,I changed something in my origin table and now the records are not splitting in the destination table. uugggghhhh

Hi MajP, I followed your advice and got it to work! My destination table had some validation rules that I didn't realize. I am able to see the split and it looks great. My last thing to do is get the rest of the fields to follow into the new table. There are alot of them, I could add them by...

Hi, Thank you for sharign this! I am able to run the code but it is not updating the new table (tblImport_Split). The array J is getting stuck on one container value and not cycling through them. Below is the code where I updated my actual table and field names. The table with the data is...

Hi MajP, Uploaded a test file. I will also try to test today and will let you know how it goes. Thanks so much! Kimhttp://files.engineering.com/getfile.aspx?folder=e3a17018-50d4-413f-bffa-1224e2e0efc8&file=TestFile_containers.xlsb

Ji Majp - Excellent questions. I will clarify. Background: These records represent inter-company invoices issued to the US office by other offices aruond the world. We are a shipping company, so the majority of these containers represent actual cargo containers, which become the reference to...

Hello, I have 5 simialr fields, each field is either null, has 1 value or multiple values separted by commas. The system which is producing this excel extract had a character limit, when reached, the string would proceed in the next column. Goal: to concatenate all the unique container...

Yes, I have determined that it is happening on the rows where a blank appears in a column before the revenue column and SAP/BW puts a pound (#) sign. I think this is causing the quotes. Any idea how to suppress the pound sign ? If not I will have to go the temp table route.

Thank you Duane! This worked however I also was able to find out how to remove the USD from the SAP Business Warehouse report which I will say here for anyone else looking fof this info: Righth-click on BW report data, properties and check the box for "Display scaling factors for key figures"...

I am importing a tab delimited file saved from an SAP BI report. Since I must leave the revenue and cost fields as text in order to import (they come with 'USD' at the end) I need to convert these values from text to numbers while in the temp table and before I append to the final import table...

Thanks for the suggestions. I have a question on the case statement. Does the code check all statements in the case before deciding which one is true or does it stop checking the cases once it returns a true? I agree it is easier to read so fine if it doesn't speed up the processing but want...

Hello, Its been a while since I did some VBA - I am running a block of code which parses a directory, checks some rules and imports a file then runs a query on the data. Then loops to the next file to check against rules, import, run the query, etc. I ran it on a directory which contained only...

I found some code that works great. I just need help to Loop it now. It should start at Row 12 column A = tbl.field.A, add new record and update field with value from Excel go to next column, column B = tblfield.b and update field with value from Excel once all columns are completed (there is a...

Hello, I have an Excel 2007 macro enabled file (xlsm) that has records in which the number of rows will change each week. The file has 3 tabs, each need to be imported into a separatte table. Each tab has a fixed number of columns tab1 Shipment Tracker into tblShipmentTracker There are 46...

I have: Visual Basic for applications Microsoft Access 12.0 Object Library OLE Automation Microsoft Office 12.0 access database engine object library

I recently upgraded to MS Access 2007 and my reference library connections are no longer there. I am trying to use MID and REPLACE functions in queries that are not working. I am trying to add Microsoft DAO 3.6 library and keep getting error 'name conflicts with existing module, project or...