Exporting Data from Quickbooks to access, Problem

[racemadnss]

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

 

[cwoody]

Solution to your problem

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)