why am I getting leading apostrophies in my columns even after I delete them? will that affect my export into the database
I am curious how the apostrophes are still there if you removed them? How did you remove them? Find/Replace?
I believe if you convert the data to a table it will eliminate the apostrophes and still keep the data as text.
Some of the column data are numbers. They are importing them into mysql and I am not sure how the constraints on the database tables are set up. If the excel file passed to us is defining the number columns as text (string) and I am importing them into the database as text (string) ... will this affect the use of these numbers as calculations? If some of the columns in excel are defined as text but are numbers can they still manipulate them for calculations in the database? Thanks in advance
ASKER CERTIFIED SOLUTION
Thanks - solution is the power query approach. I appreciate both of your assistance to resolve.