Hi,
So i was using a linked excel spreadsheet and now wish to use a direct SQL table, however i have an issue the SQL Table has a field formatted as Text the spreadsheet I was linked to had that field set as a "Number", so now having issued with all queries I have trend to convert the text file back to number using
Account: Val([AccountNo])
but this didnt work, so i imported the excel spreadsheet as then looked up the formatting within the table and the formatting is set as follows... so maybe i need to do something else in regards to formating?
So i was using a linked excel spreadsheet and now wish to use a direct SQL table, however i have an issue the SQL Table has a field formatted as Text the spreadsheet I was linked to had that field set as a "Number", so now having issued with all queries I have trend to convert the text file back to number using
Account: Val([AccountNo])
but this didnt work, so i imported the excel spreadsheet as then looked up the formatting within the table and the formatting is set as follows... so maybe i need to do something else in regards to formating?