Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

ODBC double quote problem

68 views
Skip to first unread message

Bob

unread,
Dec 30, 2011, 1:41:49 PM12/30/11
to
Hi all,

Got some Excel data trying to upload to the iSeries. I import it
into MS Access and then use ODBC/append query to upload to the
iSeries. 1906 rows are successfully inserted into the iSeries table.
Most of the rows have double quotes (") embedded in a text field
(table contains product that is sized by inch), but 6 rows return
special characters (3-F or 3-7 in hex caused by 2" 4" 8" in string).
I used create table on the iSeries and standard Client Access ODBC.
Want the data transferred "as is" with no special characters or
delimiters.
What am I missing ??

Thanks
Bob

Jonathan Ball

unread,
Dec 30, 2011, 1:48:38 PM12/30/11
to
Why the two step upload? Why not just upload directly from Excel using
the IBM i Access plug-in?

Bob

unread,
Jan 4, 2012, 9:32:37 AM1/4/12
to
Thanks for the reply Jonathan.
Looks like I was incorrect. The MS Access table that is loading an
ODBC linked iSeries table is the result of SQL Server data (ODBC link)
from the outsourced company website. Sorry for any confusion.

Jonathan Bailey

unread,
Jan 6, 2012, 6:24:44 AM1/6/12
to
Are these really just double quotes or have they become 'smart'
quotes, which curve in on each other? MS Word has a tendancy to
generate these sort of quotes.

Jonathan.

Bob

unread,
Jan 11, 2012, 8:51:23 AM1/11/12
to

> Are these really just double quotes or have they become 'smart'
> quotes, which curve in on each other? MS Word has a tendancy to
> generate these sort of quotes.
>
> Jonathan.

Curly quotes was the problem. After reviewing curly quotes and
straight quotes
in MS Word I went back to the SQL Server data source and sure enough,
there they were. You really have to look to see the difference, but
that was it.

Thanks for everyone's help.
Bob
0 new messages