Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Import from Acess problems with SQL language
I have a query in access where I use SQL code to calculate a field. In the
SQL code I have a series of if statments that use * to represent any character and # to represent any number. The query outputs the correct results in Access. When I import this to excel, it does not correctly interpret the * or #, so outputs my "then" from the if statement. Is there somewhere in Excel 2003 that I can change the language it is using to recognize the * & #? For clarification, here is an example: IIf([Type] like "8##*, "800", "x") Results in Access Type Result 825XY 800 650ZX x 875YX 800 Results I am getting in Excel Type Result 825XY x 650ZX x 875YX x Thanks! |
#2
|
|||
|
|||
Quote:
Are you using MS query to import your data? Although Access and Excel are both microsoft products their use of wildcards strangely differs. Access is "*" and Excel is "%" 2 options are to run the query first in Access as a create table query then import the results to Excel. You can automate the whole procedure with a macro. Or Swap the wild cards in Access to those compatible to Excels MS query. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Import .csv File Problems | Excel Worksheet Functions | |||
How to change German language data into Eglish Language in a colum | Excel Discussion (Misc queries) | |||
language support in excel sheet using a third party language tool | Excel Worksheet Functions | |||
Excel import problems | Excel Discussion (Misc queries) | |||
How to change the excel format from language to language? | Excel Discussion (Misc queries) |