copying table during runtime in java

[venkatesh.g]

Hi,

Kindly let me know how to copy a table(both structure and data) during runtime using java programming.

Looking for equivalent access commands for the following sql commands.

1. create table newemp select * from emp;
2. alter table newemp add userAns int;
3. update newemp set userAns=0;
4. drop table newemp;



Regards,
Venkatesh G

[June7]

One version of code to run SQL statement in VBA:

CurrentDb.Execute "CREATE TABLE newemp SELECT * FROM emp"
CurrentDb.Execute "ALTER TABLE newemp ADD userAns int"
CurrentDb.Execute "UPDATE newemp SET userAns=0"
CurrentDb.Execute "DROP TABLE newemp"

Look at http://www.functionx.com/vbaccess2003/Lesson08c.htm

[venkatesh.g]

Hi June7,

Thanks for the reply.

The code you have mentioned is VBA code. But I want to execute those queries in Java.

Regards,
gv

[June7]

Then this is not an Access question, it is a Java issue. You might try a Java forum. Look at http://www.developerbarn.com/forums/

[venkatesh.g]

Hi,

I guess this is not java query.

I'm looking for MSAccess equivalent of SQL commands I have mentioned. Simply MS Access query not VBA code.

Regards,
gv

[June7]

SQL statement is basically the same. Use the Access query designer to help you build some queries. Then you can view the SQL statement in the SQL View window of the designer. Or go straight to the SQL View and type query statement. Access Help has guidelines on using the designer. The ALTER and DROP probably can be done only in VBA.