Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2002
    Posts
    88

    Unanswered: Export Specification with DoCmd.acCmdExport?

    I think I'm trying to do something pretty simple.

    I'd just like to have some code to export the results table from a query.

    I'm using the code:

    DoCmd.RunCommand acCmdExport

    To open the export dialog. I want the export dialog, but, I want to call and export specification. I'm getting quotes around each field value. I don't want the quotes.

    Is there a way to use a an export specificaton with this command.

    If I have to I can use transfer text, but, I'd rather have the export dialog for among other things setting the path and file name and type.

    Thanks in advance

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    What are you exporting too? The quotes are a text identifyer, they'll be removed when you import them into almost anything... Could you provide more detail of the scope of your project?
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  3. #3
    Join Date
    Oct 2002
    Posts
    88
    I'm exporting mainly to Excel but I may at times what to save as a dbf or text. I'm getting the quotes in Excel and dbf. I don't recall about text.

    My db is really just used to process some information. I import a CSV file and then a query gets these values and makes a new value by concatanating two values. Then I want to export this table (without the quotes).

    Am I picking up the quotes from the import and can the be eliminated on that end? I don't see them in the import table or query.

    I've attached the db and a sample file to process
    Attached Files Attached Files

  4. #4
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Are you selecting quotes as the "text identifyer" when you import into excel?
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •