Renaming Columns

I recently changed an access database to sql and now when trying to upload infromation from a webbrowser using asp into the data base I recieve and error. I believe it is due to a space located in the column header. The column name is Due Date. I would like it to be duedate. Any ideas on how to change that. Any help would be much appreciated

I had this same problem a while back and the only solution I could find was to create a new column with the new name, move the data out of the old column and into the new column. Then you drop the old column.

That said, you shouldn't have any problems with spaces if you type out your query like this:

select [Due Date] from [owner].[tablename];

Yes that includes the [] characters.