Exporting from access database 1

[aspiringprog]

Hi all,

I have some tables in an access database that I need to export into text files. When I export these tables, I also need the name of the database(not the table)to somehow be included, either as a seperate column or as a suffix to one of the columns or simply as a header etc...

right now, after exporting the data I am manually including the name of the database. I am wondering if there is a better way of capturing the name of the database and exporting that along with the table.

Any help is appreciated.

Thanks

 

[SkipVought]

Hi,

Do a query with the DB name in a column. Export the query results.

Skip,

_[red][/red]

 

[aspiringprog]

Hi,
so you are suggesting that I run a select query, include the db name as one of the display objects, and export the results?

Will try,
Thanks.

 

[aspiringprog]

I have one more question.

These databases will change monthly. Every month a new database will be created with a new name. Is there a command wherein I can automatically get the name of the database or would I have to input the name myself in the select query?

Thanks

 

[traingamer]

You could write a function like:

Public Function CurrDB() As String
On Error Resume Next
Dim dbs As Database
Set dbs = CurrentDb
CurrDB = dbs.name
End Function

Then call it from your query:

SELECT tblname.*, CurrDB() AS DBPath
FROM tblname;

which would return ...C:\DATA\test.mdb or whatever.

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill

 

[aspiringprog]

That was perfect. Thanks