Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: Access 2010 - Convert Query into Table, Create New Database

  1. #1
    New Member
    Join Date
    Jun 2014
    Posts
    44
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Access 2010 - Convert Query into Table, Create New Database

    I'm wanting to be able to run a query and then to save the table in it's own entity, ie not to place the new table in a current Db or another Db

    I've tried using 'Make Table' but it seems the only options are to put it into another, or current, database. I want this to be a separate file, if that's possible.

    Alternatively, how would I get the results of a query in an isolated file, in order to email just that data to another destination, ie person?

    Can someone advise me, please?

    Many thanks

  2. #2
    Board Regular
    Join Date
    Jan 2009
    Posts
    1,140
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Access 2010 - Convert Query into Table, Create New Database

    you save it as a table in the current database

    then you export the table as an excel spreadsheet or as a CSV (comma delimited) text file

    then you email them the exported file

  3. #3
    New Member
    Join Date
    Jun 2014
    Posts
    44
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Access 2010 - Convert Query into Table, Create New Database

    Thanks James

    Unfortunately, I don't want to have to do all that, and only to get csv, although I realise I could then probably put into an Access/Excel table.

    I need to be able to do something on a monthly basis and it must be quick and easy

    Is there another way to create a copy of the results of a query, please? Maybe I'll have to create a Report and then 'print' as pdf.

    Many thanks

  4. #4
    Board Regular
    Join Date
    Jun 2015
    Location
    Ontario, Canada
    Posts
    1,564
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Access 2010 - Convert Query into Table, Create New Database

    You can output the results of a query or table as a pdf - no need to monkey around with in between steps. You could use a macro I suppose, although I very rarely use them, thus can't advise much about that. My preference would be a form with a button that directly outputs the query as a pdf, even to the point of emailing it - with or without any sort of preview first.
    Tips for posting problems:
    1) "doesn't work" doesn't help. Post error message text/numbers and/or state what's happening.
    2) if posting code or sql, use code tags; specify on which code line errors occur, if applicable
    3) try to be specific; assume we know nothing about your issue - because we don't!

    Make all suggested changes in copies of your database or to its objects.

    "1 out of 1010 people understand binary. The other 1001 don't."

  5. #5
    MrExcel MVP
    Moderator
    Joe4's Avatar
    Join Date
    Aug 2002
    Posts
    46,640
    Post Thanks / Like
    Mentioned
    36 Post(s)
    Tagged
    5 Thread(s)

    Default Re: Access 2010 - Convert Query into Table, Create New Database

    If you ultimate goal is to export a file, there is no need to make it a table first.
    You can export the results of a query just as easily as you can as exporting it from a table.
    As matter as fact, most anything you can do with a table you can also do with a query. So there is seldom a need to export the results of a query back to a table in order to do something with it.
    TIPS FOR FINDING EXCEL SOLUTIONS
    1. Use the built-in Help that comes with Excel/Access
    2. Use the Search functionality on this board
    3. A lot of VBA code can be acquired by using the Macro Recorder.

    "Give a man a fish, feed him for a day. Teach a man to fish, feed him for life!"

  6. #6
    New Member
    Join Date
    Jun 2014
    Posts
    44
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Access 2010 - Convert Query into Table, Create New Database

    Many thanks for all your suggestions which have given me lots of food for thought and further ideas.

    Micron - thanks. Yes, you got the point that I wanted something quick and easy, even if taking a bit more time to set up

    I'll work on these ideas and see what I can come up with.

    I appreciate your help and advice

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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