How do I click on a button in one database, then create a table in another database?

[kwokv616]

Hello!

I have some codes that will import a table fro text file, then fill in null cells with some appropriate values.

It will become so big that I need to separate this table from the others in another database and then link it.

How do I click on a button on a form in one database, then create a table in another database?

Where do I put the code for importing this table? In the original database ot the other one?

Thank you very much =)

 

[DCrake]

What makes you think that the table will be too large?

a) The number of records created
b) Too many fields
c) Physical size of the file

Are you importing it into an existing table definition or into a new table based on the contents of the text file?

David

 

[Rabbie]

One possible solution is to create your import table in a separate DB and then access it by linking to it from your other DB. See Access help for linking tables

 

[kwokv616]

I am going to link the table to the original database, but I what I dont know how to do is: Click on a button in database1, then have the table created in database 2.
I need to do that because the form is going to be used by some other user, so i need to keep the procedure for them as easy as possible.

 

[kwokv616]

my main problem is: i dont know how to create the table in a new database ><