I have to create a access table linked to an excel sheet in which some columns contain texts and some contain number(without decimals). In access table, fields size of columns that correspond to columns containing numbers in excel are set to "double". But I need that fields to be in "long integer" as I need to export that access table to a third party software where only columns with text and "long integer" values are accepted. Any way to set the column format in excel so that they will appear as "long integer" in access? Thanks.