TechRepublic Resources
- Is a SQL server my answer??
- I currently use several Pivot Tables in Excel to link to Access tables and queries. The Access tables are very large and it's becoming cumbersome to work with the Excel files that are linked. Ex. An Excel pivot that's linked to a 700K row access table is 250MB big, and...
- Tags: Microsoft Office, Databases, dmalbrough@..., server, Microsoft Excel, Microsoft Access, Access Table, Microsoft SQL Server
- Discussion threads 2007-06-04
- 10 tips for designing flexible and efficient access tables
- 10 tips for designing flexible and efficient Access tablesDo you already follow most of these design practices when you build your Access tables? What other pointers would you add to this list?A few additionsIf you are going for byte or word a
- Tags: software, design, 10 things, tables, susan harkins, Access Table, Microsoft Access, byte, JodyGilbert
- Discussion threads 2007-03-08
- How do I copy an access table with VB?
- I need to be able to copy the structure of an existing Access table in VB, checking to see if a couple of columns exist, if not, creating them, and saving them with a new name. Is this possible programatically?wrong forumput this question in Technical Q & A.OOPS!Sorry, and I...
- Tags: Access Table, Microsoft Access, Microsoft Visual Basic, table copy, access, vb, TechRepublic@..., software, database, PSchluter@...
- Discussion threads 2006-07-28
- How do I copy an access table with VB?
- I need to be able to copy the structure of an existing Access table in VB, checking to see if a couple of columns exist, if not, creating them, and saving them with a new name. Is this possible programatically?ADOXYes it is possible. Check out ADOX and ADO.Here is an...
- Tags: Access Table, Microsoft Access, Microsoft Visual Basic, ADOX, table copy, access, vb, TechRepublic@..., networking, PSchluter@...
- Discussion threads 2006-07-28
- Access- Show Leading Zero
- How do I get an Access table to store and display a leading zero in a number field?I don't think you can store a numerical value with a leading zero, but when you retrieve the value via a query you can build an expression such asExpr1: IIf([Your Table]![Your Field]
- Tags: Access Table, Field, Microsoft Access, munrrob, programming, Table, Zero
- Q&A 2005-08-01
- access table Corrupted
- I have one record within an Access Table that has become corrupted. I can't do anything with it. Have tried to delete it but get a "The search key was not found in any record." When I reach a bad field, I get a "Microsoft Access has encountered...
- Tags: Microsoft Office, Databases, Microsoft Access
- Discussion threads 2005-02-02
Additional Resources
- 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
- 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
- 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
- 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
- Copy and pasting related fields in a new table (Acess VBA)
- I am very new to Access VBA. I am creating a form with a textbox and when the user enters the information then it will search it in table XYZ within access and once it finds the results then it will copy five related fields for couple of records...
- Tags: Scripting languages, msayeed@..., VBA
- Discussion threads 2007-07-16
- Copy field from one table to another table
- Hello,I am working with Access 2003. I have a table SpotData with a field names Place and I want it to be copied to a table named Spot in a field named Place. It should be automatically done when saving the data of the form SpotData linked to the SpotData...
- Tags: Microsoft Office, dani.valverde@..., SpotData
- Discussion threads 2007-11-08
- Link an Excel database table to an Access database
- Microsoft Office is more than the sum of its parts—you can link an Excel database table to an Access database, integrating your data and adding value. Here's how. You don't have to import an Excel database table into a new Access table in order to work with it...
- Tags: Microsoft Access, Microsoft Excel, Microsoft Office, Databases, Mary Ann Richardson, database, Microsoft Office Suite Access Tips Newsletter, Office Suites, Software, Enterprise Software, Data Management
- Technical articles 2006-06-30
- Advanced Access To PDF Table Converter (msi)
- Advanced Access To PDF Table Converter is a database client utility that allows execution of SQL (Structured Query Language) statements on Microsoft Access databases. Resultsets returned by select statements are automatically persisted as PDF tables to a directory of your choice. Advanced Access To PDF Table Converter provides user interface...
- Tags: Microsoft Access, Adobe PDF
- Software downloads 2007-12-20
- Advanced Access To RTF Table Converter (msi)
- Advanced Access To RTF Table Converter is a database client utility that allows execution of SQL (Structured Query Language) statements on Microsoft Access databases. Resultsets returned by select statements are automatically persisted as RTF tables to a directory of your choice. Advanced Access To RTF Table Converter provides user interface...
- Tags: Microsoft Access, Databases, Microsoft Office, Enterprise Software, Software, Data Management, Office Suites
- Software downloads 2007-12-20
- 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
- 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 Database to Excel Pivot Table
- I need to set up Excel Pivot Tables from a Access database. Problem is that when I did it through a OLAP CUBE I get the general info and it works fine, BUT I need for them to be able to drill down to the data. You know,...
- Tags: Microsoft Office, Databases, Microsoft Excel, Access Database, Microsoft Access
- Discussion threads 2005-10-25
- Question about adding data in Access
- Im sure the answer to my problem is really simple, but I can't see it:I want to add a table of data(brought in fr Excel, currently an independant table in Access) to my db, but I need it to be divided to go into three tables that already exist in...
- Tags: j.green4@..., Microsoft Access, software
- Q&A 2005-03-31
- MS Access
- I would like to updete fields in existing Access table. I would like to add fields in that tableHmmUpdate as in change the data, from access, open the table and type, From SQlUpdate MyTable Set MyField1 = 'Value',MyField2 = 123.8 Where MyKey = 1To change the structure of a tableFrom...
- Tags: ashishab@..., vb, access database, software, Microsoft Corp., Microsoft Access
- Discussion threads 2006-08-28
- << Previous
- page 1 of 1
- Next >>
