Cannot Import/Export Calculated fields from Access to SQL

[Mohibullah]

So as many of you know, one cannot import a calculated field or export it to SQL from Access. Is there a way around this? I have tons of calculated fields and code dependent values in those calculated fields, in my Access DB.



Thanks

[John_G]

Since SQL does not support calculated fields, the best way is not to export the calculated fields at all. Use queries for the calculated data - they are far more flexible than calculated fields are.

[CJ_London]

Is there a way around this?

see this link

https://msdn.microsoft.com/en-us/library/ms188300.aspx

you still can't export the calculated field, and it may be the computed column does not meet your needs, but it is the closest you will get if you have SS 2012 or later.

[pbaldy]

Funny, I was about to post the same link. I'll add that it goes back to at least 2008, as I have that on one server.