HELP! I keep getting "Failed to Import" error when trying to import from Excel 2007/.csv/.txt. etc, to Microsoft Streets and Trips.

I have tried changing this file around in every way that I can think of without success.

What is the "Best Practice" for importing addresses?

I have been able to import a file with ONE address.

Attached Files

Phoenix Assisted Living Providers from AZ Dept of Health - Zip Sort - Name- State - deleted Tab.txt (11.2 KB)

Hi MiniZorg,

There seems to be a problem with the data format as the error message suggests. I would recommend removing the quotation marks from around one of the addresses and try again. (Do a search for WEST BELL ROAD and you'll see the problem).

Hope that helps,
Larry

Attached Images

AssistedLivingImport.JPG (131.6 KB)

Thanks Larry, I will check it out!