Search results

Using quotes doesn't work. It seems to be interpreting the 'TestEx' part right, based on the error; it's just not finding the TestEx spec, for some reason. I can't use TransferText because I'm exporting dynamically created queries/tables from VBA.

Thanks Craig. I can pretty much only find info that relates to using transfertext or manual exports, though, rather than the SQL method I'm using. I did see a sort of kludge method of using DSN={export spec name}, but I can't make it work. I have a spec named TestEx, and my SQL looks like...

Thanks for looking! I'm using a query to export a table to a text file, i.e. SELECT * INTO [Text;HDR=No;Database=C:\].[test#txt] FROM [TestTbl] Text fields end up surrounded by double quotes as a text qualifier. Is there a property I can use to get rid of the text qualifier within the SQL...

Thanks for all the replies. Since I have 33 "core" codes and 20 "calculated" codes (calculations based on addition and subtraction), continually maintaining make tables and a large union query didn't seem feasible without a lot of grief. I ended up writing a macro to make a new table with the...

Thanks for the replies! The problem with doing it in small steps is that there are so many of them that I have a whole slew of extra queries, with a union at the end, and then a maketable on the union. The second a definition changes or a new summation is added, I end up digging through the...

Hi, I have a table that looks something like this: Company Product Sales 1 A 5 1 B 2 1 C 7 2 A 8 2 B 1 2 C 2 I want a query to produce a table showing...

Thanks again, Neil. I found what I needed this time, here: http://www.access-programmers.co.uk/forums/showthread.php?t=117386 It's been a long learning process, but I've got the code working, finally.

Ok, I'm still stuck on this. I'm able to run a query which pulls all the results from the larger table, but I haven't figured out how to concatenate the results of each individual 'Like' value into one row. Using the following SQL: SELECT [Data table].Field1, [Data table].Field2 FROM [Data...

Thanks, Neil!

Bueller? Anyone?

Oops, I just realized we had some misunderstanding due to formatting. Hopefully this will clear it up: Field1 = AAAA....AA Field2 = 123 / 12345 and so on. The periods are part of the literal text of Field1. So your output should then be: Field1 = AAAA.... Field2 = 123 / 12345 098 / 87654...

Yes, that's pretty much it; just drop the last two characters of your field1 (AAAA.... and BBBB....). I'd need them in separate cells in excel, but it'd be trivial to split that up once I got to that point.

(Same person as original poster, corrected login) Thanks Moniker. The link you provided was on a similar track, but I don't think it's quite what I'm looking for. Please bear with me, as I have experience with Excel VBA, but I'm fairly new to Access... Here's a more specific explanation of...