I know this is a crazy request but I was wondering if this was possible or not. The excel worksheet that I am importing into my database has some formula's, for an example =2+2.
I am importing this worksheets, then checking fields against the main table, then exporting back to Excel. But I want to be able to keep the "=" signs when I import to remain so that when I export back into Excel the columns with the formulas will already be there.
I am importing this worksheets, then checking fields against the main table, then exporting back to Excel. But I want to be able to keep the "=" signs when I import to remain so that when I export back into Excel the columns with the formulas will already be there.
Preserving characters from Excel Import to Access
0 commentaires:
Enregistrer un commentaire