Search results

  1. C

    Export fields in XLS

    Thank you Bat17. That's what I need. It works.
  2. C

    Export fields in XLS

    Thank you for your help. Unfortunately, it not enough to solve my problem.
  3. C

    Export fields in XLS

    Yes, I want to export ALL records from the table, but all columns. the name of spreadsheet is give by the name of data from the firs column of the table like this: | column1 .. ..column x ------------------------------------------- record1: | data11...
  4. C

    Export fields in XLS

    Thank you for the answer, but the things are not quite easy for me. Yes , I would like to export data in xls files. Refering my above example if my table has many records I cannot use DoCmd.OutputTo acOutputQuery, "qryMyQuery1", acFormatXLS, "C:\MyLocation\aaaa.xls" DoCmd.OutputTo...
  5. C

    Export fields in XLS

    :( Can anyone help me?
  6. C

    Export fields in XLS

    I want to do automatically. I don't know how to make the link between the field data and name of xls in the DoCmd.TransferSpreadsheet ...method. How can I translate in code "export all records in xls files as follow : data_from_first_column.xls will contain the records with...
  7. C

    Export fields in XLS

    Hi, I have a table that contains records name1| name2 -------------- aaa | 1111 aaa | 222 bbb | 5555 bbb | 222 etc.... I need to export all records from the table in xls files as follow: if name1 = aaa -> export records in aaa.xls name1 = bbb -> export records in bbb.xls an so...
Back
Top Bottom