Welcome to SPN

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

Sign Up Now!

table properties

Discussion in 'Information Technology' started by KJR, Jul 28, 2006.

  1. KJR

    KJR
    Expand Collapse
    Guest

    Is there a way to load table data element properties in mass via excel for
    example instead of having to manually enter the information for each field in
    the table?
     
  2. Loading...

    Similar Threads Forum Date
    As A Child, Public Marches Of Sikhism Made Me Uncomfortable. They Still Do . Why ? Whats The Logic Hard Talk Oct 16, 2016
    Arts/Society Backyard Vegetable Garden Language, Arts & Culture Dec 27, 2013
    Heritage Now a Vegetable Market, Ranjit Singh's Royal Haveli a Picture of Neglect History of Sikhism Nov 11, 2013
    Sikhism Helium: 1984 and the "Periodic Table of Hate" (Jaspreet Singh) Book Reviews & Editorials Oct 28, 2013
    Heritage How our entire history was dumped in a horse stable History of Sikhism Oct 28, 2013

  3. Jeff Boyce

    Jeff Boyce
    Expand Collapse
    Guest

    I'm not following...

    What do you mean by "table data element properties"?

    Are you saying you want data that is in Excel to be in Access? If so, open
    Access and use File | Get External Data | Import ... and point to the Excel
    file.

    Regards

    Jeff Boyce
    Microsoft Office/Access MVP


    "KJR" <KJR@discussions.microsoft.com> wrote in message
    news:0EFBF4D8-6358-49EB-8B55-D3A7E11FD30F@microsoft.com...
    > Is there a way to load table data element properties in mass via excel for
    > example instead of having to manually enter the information for each field
    > in
    > the table?
     
  4. KJR

    KJR
    Expand Collapse
    Guest

    Jeff,

    Thanks for the response, but that is not what I am asking.
    When in the Design View for a Table, the only way I know to define the Date
    Type, Description, Field Size, Caption, etc is to manually enter each of them
    one at a a time. I can copy and paste but again this is one at a time.

    The table is already created or even if it is not created, but I want to
    further define the table, is there a way to upload all this into the table
    definition? I do not need to upload the actual data but I want to upload the
    meta data.

    Thanks




    "Jeff Boyce" wrote:

    > I'm not following...
    >
    > What do you mean by "table data element properties"?
    >
    > Are you saying you want data that is in Excel to be in Access? If so, open
    > Access and use File | Get External Data | Import ... and point to the Excel
    > file.
    >
    > Regards
    >
    > Jeff Boyce
    > Microsoft Office/Access MVP
    >
    >
    > "KJR" <KJR@discussions.microsoft.com> wrote in message
    > news:0EFBF4D8-6358-49EB-8B55-D3A7E11FD30F@microsoft.com...
    > > Is there a way to load table data element properties in mass via excel for
    > > example instead of having to manually enter the information for each field
    > > in
    > > the table?

    >
    >
    >
     
  5. Larry Linson

    Larry Linson
    Expand Collapse
    Guest

    "KJR" <KJR@discussions.microsoft.com> wrote

    > The table is already created or even if it is not created, but I want to
    > further define the table, is there a way to upload all this into the

    table
    > definition? I do not need to upload the actual data but I want to upload

    the
    > meta data.


    Where, and of what nature, is this table data that you want to "upload"? If
    it is in an Access table in another database, or in an Excel worksheet, you
    can simply use File | Get External Data | Import to bring it in to the
    Access database in which you are working.

    It would also be possible to create a Table, with Fields, and various
    Properties from a known-format text file, using VBA code, but that would be
    more work and I suspect is not what you have in mind.

    Larry Linson
    Microsoft Access MVP
     
  6. Douglas J. Steele

    Douglas J. Steele
    Expand Collapse
    Guest

    There's nothing built into Access that will let you do this, although I
    suppose there might be 3rd party add-ins available (sorry, I don't know any)

    However, it isn't all that difficult to code yourself, using either DAO or
    ADOX.

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


    "KJR" <KJR@discussions.microsoft.com> wrote in message
    news:028C3A41-1111-4BCB-972F-26A577C4B293@microsoft.com...
    > Jeff,
    >
    > Thanks for the response, but that is not what I am asking.
    > When in the Design View for a Table, the only way I know to define the
    > Date
    > Type, Description, Field Size, Caption, etc is to manually enter each of
    > them
    > one at a a time. I can copy and paste but again this is one at a time.
    >
    > The table is already created or even if it is not created, but I want to
    > further define the table, is there a way to upload all this into the table
    > definition? I do not need to upload the actual data but I want to upload
    > the
    > meta data.
    >
    > Thanks
    >
    >
    >
    >
    > "Jeff Boyce" wrote:
    >
    >> I'm not following...
    >>
    >> What do you mean by "table data element properties"?
    >>
    >> Are you saying you want data that is in Excel to be in Access? If so,
    >> open
    >> Access and use File | Get External Data | Import ... and point to the
    >> Excel
    >> file.
    >>
    >> Regards
    >>
    >> Jeff Boyce
    >> Microsoft Office/Access MVP
    >>
    >>
    >> "KJR" <KJR@discussions.microsoft.com> wrote in message
    >> news:0EFBF4D8-6358-49EB-8B55-D3A7E11FD30F@microsoft.com...
    >> > Is there a way to load table data element properties in mass via excel
    >> > for
    >> > example instead of having to manually enter the information for each
    >> > field
    >> > in
    >> > the table?

    >>
    >>
    >>
     
  7. KJR

    KJR
    Expand Collapse
    Guest

    Doug,

    I can see how to create tables and add or alter columns using the SQL
    Specific Data Definition DDL Query and how to alter some of the column
    properties. Unfortunately I cannot find any specific information on altering
    the caption and description properties for a data element, only some passing
    references.

    Thanks

    "Douglas J. Steele" wrote:

    > There's nothing built into Access that will let you do this, although I
    > suppose there might be 3rd party add-ins available (sorry, I don't know any)
    >
    > However, it isn't all that difficult to code yourself, using either DAO or
    > ADOX.
    >
    > --
    > Doug Steele, Microsoft Access MVP
    > http://I.Am/DougSteele
    > (no private e-mails, please)
    >
    >
    > "KJR" <KJR@discussions.microsoft.com> wrote in message
    > news:028C3A41-1111-4BCB-972F-26A577C4B293@microsoft.com...
    > > Jeff,
    > >
    > > Thanks for the response, but that is not what I am asking.
    > > When in the Design View for a Table, the only way I know to define the
    > > Date
    > > Type, Description, Field Size, Caption, etc is to manually enter each of
    > > them
    > > one at a a time. I can copy and paste but again this is one at a time.
    > >
    > > The table is already created or even if it is not created, but I want to
    > > further define the table, is there a way to upload all this into the table
    > > definition? I do not need to upload the actual data but I want to upload
    > > the
    > > meta data.
    > >
    > > Thanks
    > >
    > >
    > >
    > >
    > > "Jeff Boyce" wrote:
    > >
    > >> I'm not following...
    > >>
    > >> What do you mean by "table data element properties"?
    > >>
    > >> Are you saying you want data that is in Excel to be in Access? If so,
    > >> open
    > >> Access and use File | Get External Data | Import ... and point to the
    > >> Excel
    > >> file.
    > >>
    > >> Regards
    > >>
    > >> Jeff Boyce
    > >> Microsoft Office/Access MVP
    > >>
    > >>
    > >> "KJR" <KJR@discussions.microsoft.com> wrote in message
    > >> news:0EFBF4D8-6358-49EB-8B55-D3A7E11FD30F@microsoft.com...
    > >> > Is there a way to load table data element properties in mass via excel
    > >> > for
    > >> > example instead of having to manually enter the information for each
    > >> > field
    > >> > in
    > >> > the table?
    > >>
    > >>
    > >>

    >
    >
    >
     
  8. Douglas J Steele

    Douglas J Steele
    Expand Collapse
    Guest

    Certain properties (and I believe both Caption and Description fall in that
    category) only exist once you create them. In DAO, you'd use something like:

    Dim dbCurr As DAO.Database
    Dim tblExisting As DAO.TableDef
    Dim fldNew As DAO.Field
    Dim prpNew As DAO.Property

    Set dbCurr = CurrentDb()
    Set tblExisting = dbCurr.TableDefs("MyTable")
    Set fldNew = tblExisting.CreateField("MyNewField", dbLong)
    Set prpNew = fldNew.CreateProperties("Description", dbText, _
    "Description for MyNewField")
    fldNew.Properties.Append prpNew
    tblExisting.Fields.Append fldNew
    dbCurr.TableDefs.Refresh

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


    "KJR" <KJR@discussions.microsoft.com> wrote in message
    news:6490E246-91A2-4BC7-AF91-B2613C8CBFEA@microsoft.com...
    > Doug,
    >
    > I can see how to create tables and add or alter columns using the SQL
    > Specific Data Definition DDL Query and how to alter some of the column
    > properties. Unfortunately I cannot find any specific information on

    altering
    > the caption and description properties for a data element, only some

    passing
    > references.
    >
    > Thanks
    >
    > "Douglas J. Steele" wrote:
    >
    > > There's nothing built into Access that will let you do this, although I
    > > suppose there might be 3rd party add-ins available (sorry, I don't know

    any)
    > >
    > > However, it isn't all that difficult to code yourself, using either DAO

    or
    > > ADOX.
    > >
    > > --
    > > Doug Steele, Microsoft Access MVP
    > > http://I.Am/DougSteele
    > > (no private e-mails, please)
    > >
    > >
    > > "KJR" <KJR@discussions.microsoft.com> wrote in message
    > > news:028C3A41-1111-4BCB-972F-26A577C4B293@microsoft.com...
    > > > Jeff,
    > > >
    > > > Thanks for the response, but that is not what I am asking.
    > > > When in the Design View for a Table, the only way I know to define the
    > > > Date
    > > > Type, Description, Field Size, Caption, etc is to manually enter each

    of
    > > > them
    > > > one at a a time. I can copy and paste but again this is one at a

    time.
    > > >
    > > > The table is already created or even if it is not created, but I want

    to
    > > > further define the table, is there a way to upload all this into the

    table
    > > > definition? I do not need to upload the actual data but I want to

    upload
    > > > the
    > > > meta data.
    > > >
    > > > Thanks
    > > >
    > > >
    > > >
    > > >
    > > > "Jeff Boyce" wrote:
    > > >
    > > >> I'm not following...
    > > >>
    > > >> What do you mean by "table data element properties"?
    > > >>
    > > >> Are you saying you want data that is in Excel to be in Access? If

    so,
    > > >> open
    > > >> Access and use File | Get External Data | Import ... and point to the
    > > >> Excel
    > > >> file.
    > > >>
    > > >> Regards
    > > >>
    > > >> Jeff Boyce
    > > >> Microsoft Office/Access MVP
    > > >>
    > > >>
    > > >> "KJR" <KJR@discussions.microsoft.com> wrote in message
    > > >> news:0EFBF4D8-6358-49EB-8B55-D3A7E11FD30F@microsoft.com...
    > > >> > Is there a way to load table data element properties in mass via

    excel
    > > >> > for
    > > >> > example instead of having to manually enter the information for

    each
    > > >> > field
    > > >> > in
    > > >> > the table?
    > > >>
    > > >>
    > > >>

    > >
    > >
    > >
     

Share This Page