问题描述
我有一个导入程序，使用标准导入
规范将.csv文件导入临时表。
我遇到的问题是我有4套不同的借款人
详细信息在同一条线上，例如B1-Title，B1-Initials，B1-Surname，
B2-Title，B2-Initials，B2-Surname等
全部链接到我的主借款人表一个唯一的帐号。
我的第一个附加查询匹配哪个帐号是主要的
表的新帐号并且第一行附加没有问题，但是，第1行
借款人的详细信息被添加，查询再也无法找到账号中的差价
，现在已经存在，所以借款人的2,3
和4个细节都丢失了。
无论如何，我可以附加所有4个借款人的详细信息，以便每套借款人详细信息附加
分别到主借款人表
给出4个单独的记录，所有记录都与相同的帐号相关联？
提前感谢
Richard
Hi,
I''ve got an import procedure working, using a standard import
specification to import a .csv file into a temporary table.
The problem i''m having is that i have 4 different sets of borrower
details on the same line e.g. B1-Title, B1-Initials, B1-Surname,
B2-Title, B2-Initials, B2-Surname, etc.
all linked to my main borrower table via an unique account number.
My 1st append query matches which account numbers are new to the main
table and appends the 1st line no problem, however, as soon as the 1st
borrower details are added, the query can no longer find the difference
in account numbers, with them already now existing, so borrower''s 2,3
and 4 details are lost.
Is there anyway i can append all 4 borrowers details so that each set
of borrowers details would append separately to the main borrower table
giving 4 separate records all linked with the same account number?
thanks in advance
Richard
推荐答案
多数民众赞成我正在做的事情。我正在使用主桌上的帐号
和临时导入表来确定哪些帐户不存在
已经，然后追加第一套借款人详细信息从我的
临时表到主表。问题是，一旦我输入了第一套借款人详细信息，临时表和
主表之间的链接就丢失了（由于账户的原因）号码现在正在填充
第一借款人附加查询）所以我现在无法将
第二，第三和第四套借款人详细信息导入主借款人表。
那更清楚吗？
谢谢
Rich
Thats what i''m doing. I''m using the account number on the main table
and the temp import table to determine which accounts aren''t there
already, and then appending the 1st set of borrower details from my
temp table to the main table. the problem is, once i''ve imported the
1st set of borrowers details, the link between the temp table and the
main table is lost (due to the account number now being populated off
the 1st borrower append query) so i now have no way of importing the
2nd, 3rd and 4th set of borrowers details to the main borrower table.
Is that any clearer?
Thanks
Rich
这篇关于从导入文件的一行导入4个单独的记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！