>I've got some data I am placing into an excel sheet using automation. There are three tables totaling close to 500 fields and 50,000 records. It appears that it's going to take about 24 hours to write the data to excel. Is that right or am I doing something wrong?

besides the good ideas from Hilmar, don´t forget to make everything with excel.visible = .F., as when it´s visible, everything becomes too slooooow. :)