This software is an access modification tool that can be run on a computer that does not have access installed. It can change data and use SQL language for advanced data maintenance.
- Green versionView
- Green versionView
- Green versionView
- Green versionView
SQL statement reference
1. Copy table
select * into newtable from oldtable
select * into b from a where 1<>1 only copies the structure
2. Import from one table to another table
insert into a select * from b
3. Update table
update yourtable set name='rarely confused' where city='Nanyang'
4. Delete table
drop table yourtable

















Useful
Useful
Useful