Re: INSERT INTO...SELECT Issue

On 04/19/18 9:38 AM, Paul H. Tarver wrote:

My question is this: Has anyone here run into this issue and if so, Is there any another way or procedure around this situation that would allow me to manually fix the fieldnames which start with a number assuming I have no way to change the source data.

HUGE CAVEAT: *IF* I am understanding your question, *AND IF* I'm remembering correctly, (I don't have time to play with it) I think you can do something like:

Select "2Bad" as Mybad from goofydata.

Enclose the bad name in quotes.

--- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus