Hi there! I have this situation with an Excel file that was export from AccPac accounting software. Now they also can do it in tab delimited. However, I need to be able to export the data from the Excel file into 2 tables. I have tried back and forth with scans and parsing, but it does not work. I was wondering if anyone had a suggestion. here is what the format in excel and the txt file look like:

Ananas Boutique																	   (708) 524-8585								        Payment	   05/12/2001	17509   Inv. 5227, 5376, 5567	-0.50 

Total Ananas Boutique 					                -0.50


Anne's									

Sara Snider																	  (843) 577-3262																			Invoice	   12/28/2001	7585	Inv. 7585              101.83
		Invoice	   01/21/2002   7749	Inv. 7749              252.78

Total Anne's							       554.61

Thanks for any help!!