Access 2010 - Convert Query into Table, Create New Database
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
    29
    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,124
    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
    29
    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,516
    Post Thanks / Like
    Mentioned
    0 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
    45,158
    Post Thanks / Like
    Mentioned
    32 Post(s)
    Tagged
    4 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
    29
    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

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
  •  

 

DMCA.com