Search results

Hmmm... I don't want to output the whole database to file, I just want to output a query table to file... (I don't need it to be a dat file....) Using Informix SQL the equivalent would be: UNLOAD to "C:\test.dat" and Using Oracle SQL (I think) the equivalent is: INTO OUTFILE "C:\test.dat"

Hi, I want to "unload" my query results to a specified folder as a .dat file. I have some old SQL scripts where the command seems to be: UNLOAD to "C:\test.dat" However UNLOAD is not a legitimate command in Access... does anybody know an alternative? thank you!

JJTurner, You seem to be an access master. Could I ask you for some assistance as well?? So I was able to use the advice you gave to Casey to do a count of the number of species per sample, resulting in a table with the columns sample_id, and maxi. SELECT sample_id, Count([sample_id]) AS maxi...