将字符串值插入访问 [英] INSERT STRING VALUE INTO ACCESS

问题描述

我有一个应用程序，它将存储在变量中的数据插入到Access数据库中.

我的插入查询如下:

鳕鱼和地址是两个变量

COD ="J0020";
地址=''Ijfotech部门
ICICI银行大厦
BegKKum PeItS 1楼";

I have an application which inserts data stored in variables into access database.

My insert query is as follows:

Cod and Address are the two variables

COD="J0020";
ADDRESS="''Ijfotech Division
ICICI Bank towers
1st Floor, BegKKum PeItS''";

Insert into Distributor_Details values
('"+COD+"',
'"+ADDRESS+"'
 )

当将值插入表中时，我仅从地址中收到三行中的一行

我该如何解决这个问题?
如何从字符串变量中删除空白行?

When value is inserted into table i just receive one line of three from the address

How can I solve this issue?
How can I remove blank lines from string variable?

推荐答案

对于第一个问题，
检查字段的length(或者您要插入较少的数据)

对于第二期，
将Replace与chr(13)一起使用可删除换行符

For the first issue,
Check the length of the field(or you are inserting less data)

For the second issue,
Use Replace with chr(13) to remove newlines

这篇关于将字符串值插入访问的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！