Search results

OK - forget the place name and focus on isolating the Code and Size? Do they have a standard number of characters, or is one always in parentheses (or Brackets for a UK site!) If that's the case you can count back from the end of the string to identify your elements.

IS your data always in the format [location] "-" [location code] "("[size]")" The "" contain a literal you find in every piece of data ... If so, you can write an expression that will manipulate the text based on the positions of "-" and "(" ....

Appreciate it! Will take a look in depth later as Father's Day celebrations wind down :rolleyes:

Can anyone point me to the location of Import Specs for text files? Can you edit them?

Just like the thought never crossed his mind to contribute to the costs here ;)

You don't have to wait until you die to support this forum. Its not as if its that expensive especially when you're estate is expansive ... ;)

If you want to be certain that your charity gets something, give em the cash now. If the last one standing does run out of cash, the UK government will pick up the tab. I think they take it down to about £23,000 currently

Well - there may not be as much left over as you expect if the final one standing requires care in a home - the government essentially puts a lien on your estate to cover the cost of such care, or they may require you to use up your assets to fund such care. Given that you have no close...

Thanks plog - took your advice and found another nugget of yours elsewhere on here and finally came up with the following which works! SELECT D_Alias.Demographics_detail.Processedfile, Count(Demographics_detail.Account) AS UniqueAcc INTO tblTempC FROM (SELECT...

So - I am trying to count unique records in my table (Demographic_detail). It works perfectly when I use the following SELECT Count(*) AS N INTO tblTempC FROM (SELECT DISTINCT Account FROM Demographics_detail) AS T; However, I'd like to add a criteria to count unique where my field...

See the link to MSDN in an earlier message and attached Excel file. This was useful for me as I use a table of variables to process a large number of file variations we encounter. In my table I "lookup" to the table below, binding only to the column containing the integer. Attempts at...

I'm happy to report that replacing the AcTextTransferType with the appropriate integer works a treat. In addition to thanking all my helpers, I'm thinking of patting myself on the back - but somehwere deep in the psyche I can hear John Handel (Dad) reminding me "David, self-praise is no...

Intend to do so this morning, baldy :p

So, Gents, can I use the numerical values for each type as shown in the attached? http://msdn.microsoft.com/en-us/library/office/ff194227(v=office.14).aspx

The following code works perfectly DoCmd.TransferText acImportFixed, strImpSpec, strTable, strPathFile, boolHasFieldNames If I replace the "acImportFixed" with a string function witht he same value, it fails with an Error 13 Type Mismatch DoCmd.TransferText strTextTransfer, strImpSpec...

Well - that seems to have cleared "my wood" from the Access forest .... Done with such gentility, to boot.

I don't know is the answer to your question as every file I import is differnet so I don't use the latter DoCmd - but I'm glad you got it to work!

Saved Import is not the same as an Import Spec. The Import Spec is what you get when you've explored the Advanced button and save from that particular dialog. The import Spec is saved after you've completed defining the import fields - if you're SAved Import has your filename in it that is the...

Thanks Pbaldy - that's how I resolved it by using SUM ... The DSum came from my method of creating the Query in the Design mode and then "copying" the SQL to my VBA .... What can I say, I'm an Access dilettante! Thanks again!

strSQL2 = "SELECT COUNT(" & strTable & ".[ID]) AS CountOfID, CCur((DSum('[Balance]','[" & strTable & "]'))) AS SumBal, " & strTable & ".[Processedfile] " & _ "INTO [tblTempC&B] " & _ "FROM " & strTable & " " & _ "WHERE...