Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Use of ALTER TABLE command
I have been doing this manually, but want to use a command button with code underneath. Had come upon the ALTER TABLE command and had hoped it could be used to simplify and automate the process.- Obione01
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Use of ALTER TABLE command
Have imported an Excel 2003 spreadsheet into Access 2003 using the Docmd.TransferSpreadsheet command. Now, I want to ALTER the imported TABLE to: 1) Remove unneeded fields, 2)Rename the four remaining fields (which do not have useable headers), and 3) Change field attributes, such as, Type...- Obione01
- Thread
- Replies: 3
- Forum: Microsoft: Access Modules (VBA Coding)
