Exporting tables with date as name

T

tfoulkes

Hi,
I've got a macro running which exports a table to another databas
using transfer database.
I was wondering if anyone was aware of a way that I can give this tabl
the current date instead of always the same name?

Muchos Gracias
 
L

Luiz Cláudio

Hi,

in MS-Access help, look up for "TransferDatabase method" and read about the
parameters you can pass.

You can use Format$() function to create a string with the date:
Format$(Date(),"mmddyyyy") = "11282003"

[]
Luiz Cláudio C. V. Rocha
São Paulo - Brazil
 
Top