Macro that renames a table

[HarryStamper]

I am trying to get a macro to rename a table with the name and concatenate the month and day....so I want the rename macro to take BSC151 and rename it to BSC151-0801.
I tried something like this...BSC151 & Month(Date) & Day(Date), but it took it literally and did not expand it.
Any ideas.

 

[PHV]

Any ideas
Yes, use VBA instead of macro.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[lespaul]

Can you post the actual SQL you used to try and change the table name?

Can you please expand on why you are doing this? Having multiple copies of identical tables with date names raises all kinds of flags about normalization.





Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases:
The Fundamentals of Relational Database Design
Understanding SQL Joi

 

[HarryStamper]

THanks...VBA was the way to go..it was a piece of cake.