copying a table into an external file?

[MissiMaths]

I need to be able to place a copy of tables I create within vb and
access, and place them in another file as a sort of back up.

First I create a folder "created folder" in which to put the tables:

MkDir "C:\Documents and Settings\My Documents\created folder"

This works, so now I wish to put two tables (table1 and table1detail)
into this folder. One of these tables may contain hundreds of
thousands of records (possible but not usual). I can't seem to be able
to execute this. I have tried CopyFile, MoveFile, TransferSpreadsheet,
TransferTable. I am sure that this is very simple and I was probably
just missing a comma somewhere but I just can't see where I'm going
wrong.

Ideally the type to file I would like to save these tables as in their
copied form would be that with the most efficient storage but one that
would maintain all the data and structure properly. Some kind of .DBF
or even .XLS? I really would appreciate some words of wisdom on this
too!
Thank you so much for any responses!

[Tom van Stiphout]

On 8 Oct 2004 06:35:45 -0700, mi********@hotmail.com (MissiMaths)
wrote:

How about making a copy of the MDB itself? Simple, and highly
recommended.

-Tom.

I need to be able to place a copy of tables I create within vb and
access, and place them in another file as a sort of back up.

First I create a folder "created folder" in which to put the tables:

MkDir "C:\Documents and Settings\My Documents\created folder"

This works, so now I wish to put two tables (table1 and table1detail)
into this folder. One of these tables may contain hundreds of
thousands of records (possible but not usual). I can't seem to be able
to execute this. I have tried CopyFile, MoveFile, TransferSpreadsheet,
TransferTable. I am sure that this is very simple and I was probably
just missing a comma somewhere but I just can't see where I'm going
wrong.

Ideally the type to file I would like to save these tables as in their
copied form would be that with the most efficient storage but one that
would maintain all the data and structure properly. Some kind of .DBF
or even .XLS? I really would appreciate some words of wisdom on this
too!
Thank you so much for any responses!

[Lyle Fairfield]

mi********@hotmail.com (MissiMaths) wrote in
news:75**************************@posting.google.c om:

I need to be able to place a copy of tables I create within vb and
access, and place them in another file as a sort of back up.

First I create a folder "created folder" in which to put the tables:

MkDir "C:\Documents and Settings\My Documents\created folder"

This works, so now I wish to put two tables (table1 and table1detail)
into this folder. One of these tables may contain hundreds of
thousands of records (possible but not usual). I can't seem to be able
to execute this. I have tried CopyFile, MoveFile, TransferSpreadsheet,
TransferTable. I am sure that this is very simple and I was probably
just missing a comma somewhere but I just can't see where I'm going
wrong.

Ideally the type to file I would like to save these tables as in their
copied form would be that with the most efficient storage but one that
would maintain all the data and structure properly. Some kind of .DBF
or even .XLS? I really would appreciate some words of wisdom on this
too!
Thank you so much for any responses!

If you are running an mdb or adp application try running this code:

SaveAsText 6, "", FileName

where FileName is the name (and path) of the file to which you would like
your tables saved.