Thread: Export to .bat file in microsoft.public.access.externaldata

  I need to export a list of names to a .bat file so that I can create folders. I created the query to get the names out, but when I export using SendObject there are text lines all around my names. I cannot then rename it to make the .bat file. Is there a way to export to a text file from a query or table that will not draw the lines for me? -- Thanks As Always Rip  

  You could export it using the TransferText method. Easiest way to create it is to make a macro that uses the TransferText action, add the values you want, then (after saving the macro) convert the macro to code with the SaveAs Module option. Then you'll have the VBA code for the TransferText method. -- --Roger Carlson MS Access MVP Access Database Samples: www.rogersaccesslibrary.com Want answers to your Access questions in...