G
Guest
Hello - After importing an Excel spreadsheet into Access 2000 (file, get
external data), one Excel formula doesn't work right. Here is the Excel
formula:
=IF(SUM(IF($F$4:$F$1284=F4,1))>1,"XXX","")
Basically all it does is search through a column for duplicates and kick it
out to the next column. After importing into Access I get the following in
the "_importerrors" log:
Type Conversion Failure F7 3729
Will this formula work in Access? Is there another way to achieve my goal in
Access?
THANKS!!
Jason
external data), one Excel formula doesn't work right. Here is the Excel
formula:
=IF(SUM(IF($F$4:$F$1284=F4,1))>1,"XXX","")
Basically all it does is search through a column for duplicates and kick it
out to the next column. After importing into Access I get the following in
the "_importerrors" log:
Type Conversion Failure F7 3729
Will this formula work in Access? Is there another way to achieve my goal in
Access?
THANKS!!
Jason