Recent content by zzpprk

Here is a sample of my code. Function AddData(theData() As String, theText, theCount As Long) As Long If Not (IsNull(theText)) Then theText = Trim(theText) If theText <> "" Then theCount = theCount + 1 theData(theCount) = UCase(theText) End If End If AddData =...

This is exactly what I did but found all this table updates a little slow so I used an array of strings as the second table. Makes things a little quicker.

You are right but I, or the company I work for, have no control on the way the Goverment enters its data.

Hi You are right. It would have been much easier if the data was a simple list of text strings in a text file. The reallity is that it is in this weird format in a spreadsheet and that users do not want to even save the dam thing in CSV format. The result is that I am stuck with this...

Hi Cannot tell you what it is for. Just that the list is provided by the Goverment and posted on their web site. Regards Patrick

Hi twoplustwo The search is quite tricky because you need to take account of spaces around the name to search. For example, if you search for "WEST" then you want to return "FRED WEST" and "WEST FRED" but not "NORTHWEST". Do you see what I mean? I have a query that returns all the records...

Hi twoplustwo Many thanks for all your help. It is much appreciated. Basically, I am running checks against a list of names which just happens to be split across six columns in an Excel spreadsheet. A bit daft but there is nothing I can do about the format of the data. Regards Patrick

Hi That has worked!!! Thanks so much. Now, I get a table with six fields as I've imported six columns. I really need all this data is a single list so, for example, instead of having six records of six fields, I get 36 records of a single field. Is there an easy way of doing this? Regards...

Hi Sorry if I was unclear. As far as I can tell, there will only be one workbook which the user will run the processing against. If there are more then the user will just repeat the process. The processing Access needs to perform in only against the data in one workbook. Hope that...

Hi That won't do because users are really not happy about doing things like that. They want to click a button and the whole thing is done for them without going through wizard screens. The spreadsheet will always be in the same format so the data extraction process can be automated. I...

Hi twoplustwo Wow!!! So quick. Thanks for assisting. This is just a one-off thing in the sense that Excel will no longer be required once the data is extracted. This whole process will occur on the click of a button in a form so the user might decide to do this several times but I doubt it...

Hi Hope one of you can help me. I need to open an Excel spreadsheet and extract some data from it. Can I do this from Access VBA code? Regards Patrick