11-14-2008 01:46 PM
11-14-2008 10:29 PM
Hard to say without more information. Do you have the actual text file closed, you won't be able to import if the file is open at the same time you are trying to open it.
I would also suggest saving your text file as a .csv file instead. See how that goes.
11-15-2008 02:19 PM
11-19-2008 12:50 PM
11-20-2008 09:09 AM
This can be a bit flaky. If you are currently importing as a csv file, try saving the Excel data as Text (Tab Delimited) then importing it in to ACT (select TAB in the wizard). Usually works if csv is a problem.
11-20-2008 09:43 AM
11-21-2008 10:20 AM
Try creating a simple 5 row excel file with just Contact, Company, Address 1,and City columns and some made up data and see if that works. If it does it suggests there might be a problem with your spreadsheet, and I would run a clean-up macro to remove bad characters before trying again.
It might also be worth trying to import the file into the demo database. If that works but the other one doesn't it could well be database specific, in which case hit it with all the fixes and rebuids in ACT Diag (I presume you've already done this) and try again.If that doesn't work you might be looking a database rebuild - create an empty copy of your database then import your old one into the new one. this has worked for me in the past.
11-24-2008 06:55 AM
11-26-2008 02:25 AM - last edited on 11-26-2008 08:39 AM by dlunceford