Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- Use SQL to quickly create a new table from existing records in Access
- SQL lets you use one command to quickly create a new table containing a subset of records from a larger table while working in Access. Sound complicated? It's not, as Mary Ann Richardson shows us. SQL Server lets you use one command to quickly create a new table ...
- Tags: Microsoft Access, SQL, Microsoft Office, Databases, Mary Ann Richardson, Fort Myers, new table, Microsoft Office Suite Access Tips Newsletter, Table, Office Suites, Software, Enterprise Software, Data Management
- Technical articles 2006-02-28
Additional Resources
- How to continuously append live table to table?
- I have a situation here:every month there will be a table (with 3200+- entries) that should be appended to a Year-to-Date table.I appended the second month's live table to the accumulative table, but don't know how to do it for the third month, other than deleting the live table temporarily...
- Tags: shichen1979@...
- Discussion threads 2007-05-31
- Copying a table using VB
- What is the easiest way to copy data and structure from 1 table to another table within the same database? it doesn't matter if table b is overwritten, I need a way to copy table A to table B
- Tags: Microsoft development tools, Programming languages, andrew.s.fitchett@..., Microsoft Visual Basic
- Discussion threads 2007-08-27
- Transfer data from one table to another in Access
- I need help on a topic in Access. I have an existing table with people's information. Then I have another table of people's information which is not up to date. For every person in the old table, I would like to check it in the new table and if present...
- Tags: o.kulahcioglu@..., Microsoft Access
- Discussion threads 2007-07-17
- MIL - Read Table (zip)
- MIL - Read Table is a powerful automation tool that can read table from SAP. Using this application, you can instantly view and search table and data from SAP. MIL - Read Table is designed for high flexibility, numerous options enable you to read SAP table that best suits your...
- Tags: SAP AG, Microsoft Windows, .Net, Productivity, Operating Systems, Software, Software Development, Software/Web Development
- Software downloads 2008-02-05
- Compare Sheets (zip)
- Compare two tables created with MS Excel and create result table according to given criteria. Depending on compare function result table may include: lines from first table that have match in second table, lines from first table that haven't match in second table, lines from both tables that haven't match...
- Tags: Table, Ventsislav Alexandriyski, Microsoft Excel, Microsoft Office, Office Suites, Software
- Software downloads 2005-11-28
- Populate Info from table to access form
- I have a form that has SSN / Name / DOB / Servicing office employees table. Then I have the input table with SSN and other fields input table. On the form I have the SSN fields linked and then I call the SSN field on the form...
- Tags: SSN
- Q&A 2005-09-12
- Can we clone a table structure to temp table in SQL server
- Can we clone a table structure to temp-table in SQL server stored procedure?If yes, how should we declare the temp table and the command the clone the table structure?or can provide us a sample codes on the above solution.ThanksAnnoyingly simpleselect * into #temptable from Tableif you only want the structureSelect...
- Tags: ysgoh3@..., Microsoft SQL Server, server
- Discussion threads 2007-05-09
- Compare records in 2 tables and move data from one table to the other
- I have two tables with 3 columns in common: FirstName, LastName, Department. Table A Access table has additional columns (RecordID, Address, Phone, etc. This table is missing data in the some of the records in the Department field.Table B an Excel spreadsheet is missing no data in any...
- Tags: Microsoft Office, Table
- Discussion threads 2005-08-11
- Access Hacks: Create Access Tables From Outside Access
- One has an Excel solution that needs to populate an Access table. The table will be a new table in the database. One might think the table needs to exist before one can populate it via ADO or some other means, so one manually creates the table and then goes...
- Tags: Microsoft Access, Table, Microsoft Office, Microsoft Excel, Databases, Office Suites, Software, Enterprise Software, Data Management
- Book chapters 2005-04-14
- copy table from dataset
- I need to copy table from a dataset then return saved copy into the original table.dim cpytbl as new datatablecpytbl = ds.table("name").copyentr processds.table.("name") = cpytbl this statement give an error "Property 'Item' is 'ReadOnly' "can you helpSeems to be a fundamental error hereWhy are you trying to do this?I can...
- Tags: sahaah@...
- Discussion threads 2007-02-25
- Update data from one table to another table
- Greetings:I have two sql 2000 databases, one on one server and one on another server. After bringing in the data from one table, I would like to update the other database table with the changed data.Quick and dirtyTruncate Table OutOfDateInsert OutOfDate Select * From UpToDate
- Tags: Storage, Databases, greg_gordon@...
- Discussion threads 2007-07-23
- Inserting data from one table in access into another
- I am creating an access db, and I've imported an excel spreadsheet into the db. I've created the table in access with the fields that I want to have in the table, but I am drawing a blank on how to update the table in access with the excel...
- Tags: Microsoft Excel, daintysally
- Discussion threads 2007-10-15
- Periodic Table of the Elements (rar)
- Free interactive periodic table program for MS-DOS. You can add new elements to the Mendeleev Table. Just edit file mendel.txt in Notepad Editor. For movement trough the table use cursor control keys.
- Tags: Courseworking
- Software downloads 2006-03-14
- Copy an existing table structure into a new Access database
- If you've been searching for a way to use the table structure in an existing Microsoft Access database in another table, then check out this quick tip. It shows how to copy and customize the table structure to a new table in another database. Have you been eyeing a...
- Tags: Microsoft Access, Storage, Databases, Mary Ann Richardson, Microsoft Office, database, table structure, Microsoft Office Suite Access Tips Newsletter, Structure, Hardware, Enterprise Software, Software, Data Management
- Technical articles 2005-07-26
- Periodic Table (zip)
- The periodic table--the cornerstone of chemistry--expresses in a compact form the relationships between all the elements in the universe. Synergy Creations' Periodic Table 4 is a versatile chemistry reference tool for your Windows XP computer that takes the periodic table beyond the simple paper periodic table found in so many...
- Tags: Chemist, Synergy Creations, Productivity, Microsoft Windows, Microsoft Windows XP, Operating Systems, Software
- Software downloads 2006-11-09
- Table Control (rar)
- Since the only way to view data in tabular format in most Microsoft .NET languages is via datagrid that is hardly a table control we decided to create a table control for the purpose of viewing and manipulating data in tabular format. Table Control allows you to view any textual...
- Tags: Format, .Net, Application Servers, Middleware, Software Development, Software/Web Development, Enterprise Software, Software
- Software downloads 2006-11-10
- Word document into Excel
- I am copying a word table into excel. Some cells in the word table contain text in bold format. When I copy the table into excel excel creates a new cell for the portion of the text in bold. The columns to the right of that column are then incorrectly...
- Tags: Microsoft Excel, Microsoft Word, smh51156@..., software
- Q&A 2005-09-08
- Transfer data from one table to another in Access
- I need help on a topic in Access. I have an existing table with people's information. Then I have another table of people's information which is not up to date. For every person in the old table, I would like to check the name in the new table and if...
- Tags: Databases, o.kulahcioglu@..., Microsoft Access
- Discussion threads 2007-07-17
- Table Tennis Screensaver (exe)
- It has a Table tennis table background with table tennis balls bouncing over the screensaver. This version is the first release on CNET Download.com.
- Tags: Background, Screensaver
- Software downloads 2007-11-29
- << Previous
- page 1 of 1
- Next >>
