Search results for query: *

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...

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...

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...

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 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...