Forum Discussion

NoreenJustice's avatar
NoreenJustice
Qrew Trainee
6 years ago

Auto Import from Excel Resulting in Character Problems

I am using an auto import (.net tool that uses the QB API built by someone else) process to load records into QB from an .xlsx file. The file contains text fields that are coming over with some chara...
Data import and export
excel
DonLarson's avatar
DonLarson
Qrew Elite
6 years ago
Noreen,

This sounds like an Encoding problem.   The .Net script needs some tweaking to make sure that the non alphanumeric characters such as ",% are parsed and Encoded to be imported.  I have had this problem multiple times with moving data in and out of QB.

You should go back to the original developer and discuss the issue.

------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------
NoreenJustice's avatar
NoreenJustice
Qrew Trainee
6 years ago
Thanks Don, I appreciate the feedback!

------------------------------
Noreen Justice
------------------------------