I have a table in an existing database that I would like to export to a new
database using an event procedure or macro. I would like to name the new
database with the date it is created. Any suggestions?
--
Dar

You can create the database like this:
Dim ws As DAO.Workspace
Dim dbBackup As DAO.Database
Dim strFile As String
strFile = "C:\" & Format(Date, "yyyymmnn") & ".mdb"
Set dbBackup = ws.CreateDatabase(strFile, dbLangGeneral)

You can then execute an Append query statement to add the table to the
database. Create a query using the table you want to export. Change it to an
Append query (Append on Query menu). Access gives you a dialog where you can
specify the name of the external file to export to.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"DarS" <(E-Mail Removed)> wrote in message
news:93B60EA4-6721-4C04-ABD4-(E-Mail Removed)...
>I have a table in an existing database that I would like to export to a new
> database using an event procedure or macro. I would like to name the new
> database with the date it is created. Any suggestions?
> --
> Dar

Thank you!
--
Dar


"Allen Browne" wrote:

> You can create the database like this:
> Dim ws As DAO.Workspace
> Dim dbBackup As DAO.Database
> Dim strFile As String
> strFile = "C:\" & Format(Date, "yyyymmnn") & ".mdb"
> Set dbBackup = ws.CreateDatabase(strFile, dbLangGeneral)
>
> You can then execute an Append query statement to add the table to the
> database. Create a query using the table you want to export. Change it to an
> Append query (Append on Query menu). Access gives you a dialog where you can
> specify the name of the external file to export to.
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia.
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "DarS" <(E-Mail Removed)> wrote in message
> news:93B60EA4-6721-4C04-ABD4-(E-Mail Removed)...
> >I have a table in an existing database that I would like to export to a new
> > database using an event procedure or macro. I would like to name the new
> > database with the date it is created. Any suggestions?
> > --
> > Dar
>
>
>