trouble, as the string includes a " character. The query in my debug screen
looks like this:
INSERT INTO scripts (
SRXNO,
SDISPDATE,
PTITLE,
PFIRSTNAME,
PSURNAME,
PADDRESS,
PSUBURB,
PPOSTCODE,
PMEDICARE,
PMEDICDATE,
PCONCTYPE,
PCONCNO,
PCONCVDATE,
PSAFENTNO,
PREPATNO,
SDOCPRESNO,
SDOCNAME,
SDRUGDESC,
SALTDESC,
SQTY,
SAUTHORITY,
SSIGS,
SWARDNO )
VALUES (
'xxxx',
'21-Jul-04',
'MR',
'xxxxx',
'xxxxxx',
'xxxxxxx',
'xxxxx',
'xxxxx',
'xxxxxx',
'xxxxx',
'NULL',
'NULL',
'NULL',
'NULL',
'NULL',
'xxxx',
xxxxx',
'"BLEOMYCIN (BL) INJ 15',
'000 i.u."', -------> this is where my problem is, the text string that
should be here is:
"BLEOMYCIN (BL) INJ 15000 i.u."
'BLEOMYCIN SULFATE',
'2',
'FALSE',
'for 21/7' )
I am importing into an access db from a csv file supplied from a pharmacy,
so I cannot choose the formatting of this data, this is what I have to work
with.
I just don't know what it is breaking the string at the '000 i.u." I can
only assume it is because the string has double quotes in it ????
Thanks in advance.
----------------------------------------------------------------
The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. It is the responsibility of the recipient to ensure that the onward transmission, opening or use of this message and any attachments will not adversely affect its systems or data. Please carry out such virus and other checks, as you consider appropriate. To the fullest extent allowed by law, no responsibility is accepted by Haematology & Oncology Clinics of Australasia for any virus damage caused by this message.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
