Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

copying tables in Access to a cd

Discussion in 'Information Technology' started by Linda, Nov 18, 2005.

  1. Linda

    Linda
    Expand Collapse
    Guest

    I need to copy 4 tables from an Access database to send to the state on a cd.
    I can send the entire database but most of this information is protected by
    law . "Help" in the case wasn't any help. Can someone tell me how to do
    this?
     
  2. Loading...

    Similar Threads Forum Date
    Opinion Akal Takht concerned on drug addiction, copying during exams Breaking News Nov 5, 2013
    India 11 Constables Get Pregnant at Training School Breaking News Apr 26, 2011
    Warm Up with Winter Vegetables (Vegetarian Casseroles) Cooking & Recipies Feb 7, 2011
    India Two constables arrested for beating, extortion Breaking News Jul 27, 2010
    History Cleaning Out the Augean Stables Punjab, Punjabi, Punjabiyat Aug 25, 2009

  3. Douglas J Steele

    Douglas J Steele
    Expand Collapse
    Guest

    Tables in Access don't have an existence of their own: they can only exist
    inside an MDB (or MDE) file.

    One option is to create a new database, and import the 4 tables into the new
    database (through File | Get External Data | Import).

    Another is to export the data to, say, Excel, and send the spreadsheet.

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no e-mails, please!)


    "Linda" <Linda@discussions.microsoft.com> wrote in message
    news:D800C3DF-677E-47DA-A567-BB8466926144@microsoft.com...
    > I need to copy 4 tables from an Access database to send to the state on a

    cd.
    > I can send the entire database but most of this information is protected

    by
    > law . "Help" in the case wasn't any help. Can someone tell me how to do
    > this?
     
  4. KARL DEWEY

    KARL DEWEY
    Expand Collapse
    Guest

    You best and easiest way is to build a query that gives you the data you wish
    to convey. Run the query and then click in the upper most left corner to
    highlight all the results, copy and then paste in a Word document. It will
    paste as a table in Word.

    "Linda" wrote:

    > I need to copy 4 tables from an Access database to send to the state on a cd.
    > I can send the entire database but most of this information is protected by
    > law . "Help" in the case wasn't any help. Can someone tell me how to do
    > this?
     
  5. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    Linda wrote:
    >I need to copy 4 tables from an Access database to send to the state
    > on a cd. I can send the entire database but most of this information
    > is protected by law . "Help" in the case wasn't any help. Can
    > someone tell me how to do this?


    Having been with a State tax department, I suggest you start by finding
    out what format(s) the state will accept.

    Assuming they will accept Access, you could copy your current mdb and
    then delete the tables and fields that have information you do not want to
    pass on to the state. Then send them that database.

    It could be they would prefer a text file likely comma delineated.

    --
    Joseph Meehan

    Dia duit
     
  6. Linda

    Linda
    Expand Collapse
    Guest

    Thank you, it worked!!

    "Douglas J Steele" wrote:

    > Tables in Access don't have an existence of their own: they can only exist
    > inside an MDB (or MDE) file.
    >
    > One option is to create a new database, and import the 4 tables into the new
    > database (through File | Get External Data | Import).
    >
    > Another is to export the data to, say, Excel, and send the spreadsheet.
    >
    > --
    > Doug Steele, Microsoft Access MVP
    > http://I.Am/DougSteele
    > (no e-mails, please!)
    >
    >
    > "Linda" <Linda@discussions.microsoft.com> wrote in message
    > news:D800C3DF-677E-47DA-A567-BB8466926144@microsoft.com...
    > > I need to copy 4 tables from an Access database to send to the state on a

    > cd.
    > > I can send the entire database but most of this information is protected

    > by
    > > law . "Help" in the case wasn't any help. Can someone tell me how to do
    > > this?

    >
    >
    >
     
  7. Linda

    Linda
    Expand Collapse
    Guest

    Thank you for the information. Will give it a try.

    "KARL DEWEY" wrote:

    > You best and easiest way is to build a query that gives you the data you wish
    > to convey. Run the query and then click in the upper most left corner to
    > highlight all the results, copy and then paste in a Word document. It will
    > paste as a table in Word.
    >
    > "Linda" wrote:
    >
    > > I need to copy 4 tables from an Access database to send to the state on a cd.
    > > I can send the entire database but most of this information is protected by
    > > law . "Help" in the case wasn't any help. Can someone tell me how to do
    > > this?
     
  8. Linda

    Linda
    Expand Collapse
    Guest

    Thank you very much.

    "Joseph Meehan" wrote:

    > Linda wrote:
    > >I need to copy 4 tables from an Access database to send to the state
    > > on a cd. I can send the entire database but most of this information
    > > is protected by law . "Help" in the case wasn't any help. Can
    > > someone tell me how to do this?

    >
    > Having been with a State tax department, I suggest you start by finding
    > out what format(s) the state will accept.
    >
    > Assuming they will accept Access, you could copy your current mdb and
    > then delete the tables and fields that have information you do not want to
    > pass on to the state. Then send them that database.
    >
    > It could be they would prefer a text file likely comma delineated.
    >
    > --
    > Joseph Meehan
    >
    > Dia duit
    >
    >
    >
     

Share This Page