I am trying to export the address book from Quickbooks in to may Access 2k Database

I exported the Quickbooks file out to an Excel File, The only problem is the Ship to: Addresses are not parsed into Street, city, State, zip. It looks like this.

Company name 1234 StreetAddress City, State Zip

My table has [Company Name],[Street],[City],[State],[Zip]

I was going to import it into a temporary table then append the records to The Clients table, but I ran into this problem.

How do I parse the Address from QB and place it in my table?

*NOTE* I have 500+ records :eek:

There have been several address/name parsing routines posted here. Try searching for an appropriate one.

Use a query to reverse concatinate the field. This will split the data in the field just as you want it if you specify your criteria. Import the data only into your predisigned tabe. (Nb You can also do this in XL before you import your data)