This topic has been archived. It cannot be replied.
-
工作学习 / IT技术讨论 / 请教各位DX：有两个ACCESS数据库表内容差不多，但不完全相同，FIELD的个数也不同。现在要将一张表的内容合并到另外一张表，除了人工完成外有没有方便一些的方法？多谢！
-robinleo(Robin);
2001-12-10
(#292515@0)
-
Write a script to do it... Like an ASP script or something.....
-jeffrey815(Smartiecat);
2001-12-10
(#292516@0)
-
or modify the existing table to the same column as the other one,and then copy and paste everything.
-jeffrey815(Smartiecat);
2001-12-10
(#292517@0)
-
写个SQL不就得了. 用INSERT就行.
-zjoy(Joy);
2001-12-10
(#292550@0)
-
That's ACCESS....Its query only take SELECT. If it's SQL Server, it's a different story.
-jeffrey815(Smartiecat);
2001-12-10
(#292551@0)
-
你用的哪个版本的ACCESS? 我用ACCESS不仅可用INSERT, DELETE, UINION 都可以用啊
-zjoy(Joy);
2001-12-10
(#292553@0)
-
Where do you input the SQL? When I use Access, I remember I choose SQL view under Query and it only take very simple SQL select statement. Can't do any computed column and can only do very simple function.
-jeffrey815(Smartiecat);
2001-12-10
(#292555@0)
-
you can select the type of query. after you select table when you create query, select query type under Query menu, such as insert, update...
-lilyba(Sunshine);
2001-12-10
(#292571@0)
-
i see i see......
didn't know that.... Thanks.
-jeffrey815(Smartiecat);
2001-12-10
(#292576@0)
-
make a query.
-lilyba(Sunshine);
2001-12-10
(#292554@0)