An error occurred while preparing the query

Question

SELECT SUBSTRING(UGB,1,9) as EntityCode, SUBSTRING(FUNCIONARIO/CREDOR DESCONTADO,1,9) as NRCId, SUBSTRING(FUNCIONARIO/CREDOR DESCONTADO,11,75) as CustName, VALOR as ReceiptAmount FROM [SubmissionDetails$]

for execution against OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)".

to read these data from excel

when fields have special characters of spaces use [ ] [FUNCIONARIO/CREDOR DESCONTADO] — T.S.
– T.S., Commented Jun 7, 2023 at 15:03

Onke · Accepted Answer · 2023-06-07 15:06:20Z

0

The FUNCIONARIO/CREDOR contains a special character(/), so I would suggest you use square brackets.

answered Jun 7, 2023 at 15:06

Onke

1131 silver badge8 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Sugi Joshuva Over a year ago

An error occurred while preparing the query "SELECT SUBSTRING(UGB,1,9) as EntityCode, SUBSTRING([FUNCIONARIO_CREDOR DESCONTADO,1,9]) as NRCId, SUBSTRING([FUNCIONARIO_CREDOR DESCONTADO,11,100]) as CustName, VALOR as ReceiptAmount FROM [SubmissionDetails$]" for execution against OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)". STILL SHOWING SAME ERROR

T.S. Over a year ago

@SugiJoshuva post the call stack from the error. and from inner exception if there is one. And not in comment, but edit your question

Collectives™ on Stack Overflow

An error occurred while preparing the query

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related