Recent content by bcarneyAEP

OK I have the excel VBA code to import the text file. How do I modify the code to manipulate the data line and pull out the the info I am looking for and put it in a seperate cell? Here is the VB code I have so far: Sub ReadTextFile() Dim fnum Dim strField1 As String, strField2 As...

Thanks for the quick reply. I forgot one caveat, I am not a programer. I'll lok at the function but I doute I'll be able to make heads or tales out of it. Oh using Excel 2010 B.

Hi everyone! I need some assistance with an Excel import issue. The General synopsis is I want to create and Excel Macro or script to import a file into Excel and parse some data into separate cells. The text file is basically an application log file dumped to a text file. The file starts with...

Great I figured it out!!!! I had aliased the column names and put the alias names in the code. Removed the (As [Alias name]) from the code and everything works. THANKS!

Great! Thanks for the help. I copied your code and modified it to fit the actual names of the fields in the table. There is one issue, the result only returns False, even when the condition is True.. Any addtional suggestions? Brian

I am new to SQL and trying to convert a process that is currently run using Access and Excel. I've run into one issue, Excel has a process that evaluates a number of cells and returns a single yes (TRUE) or no (FALSE) in a diffrent cell. I have not been able to figure out how to do this in an...

Hi I am converting an Excel spreadsheet to an Access DB. The Excel sheet has a formula that inspects a quantity of cell for "yes". If yes is found in any of the cells it places a yes in a single colunm (Excel code provided below). How can I do the same Lookup in an Access query? Excel...

Hi I am trying to convert a Memo field to a Text field in a Make Table query. How can I do this? Thanks In advance Brian