Preserving characters from Excel Import to Access

[jadown]

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.

 

[CJ_London]

I'm not aware of a technique for doing this but as an alternative, if you are only checking data and not changing it, why don't you link to the excel data rather than importing it.

 

[CJ_London]

This current link may provide a solution of sorts

http://www.access-programmers.co.uk/forums/showthread.php?t=275122