Exporting tables with date as name

  • Thread starter Thread starter tfoulkes
  • Start date Start date
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
 
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
 
Back
Top