Topic: Saving of initial formatting of cells at import of the table from Excel in Access
All greetings! I need to import the table an ex-fur-tree in .
I do it by the following command
SELECT * INTO newtable23 FROM (SELECT CCD_0D_02, CCD_02_01, CCD_02_02, CCD_02_03, CCD_02_04, CCD_02_05, CCD_02_06, CCD_02_07, CCD_02_08, CCD_02_09, CCD_02_10; CCD_08_01, CCD_08_02, CCD_08_03, CCD_08_04, CCD_08_05, CCD_08_06, CCD_08_07, CCD_08_08, CCD_08_09, CCD_08_10, CCD_09_01, CCD_09_02, CCD_09_03 FROM 2014 WHERE CCD_33_01_ between "7304000000" and "7306999999")
This code works, but in the created table access in some columns the data type with numerical on the text changes. Prompt, how it is possible to save initial formatting ?