N
New User
Dear all,
I have a question about "relative" directory name in append query.
I am using a following append query;
INSERT INTO AIS ( MRDID, MRDDOB)
SELECT [Sheet1$A1:F100].ChaseID, [Sheet1$A1:F100].MemberDOB
FROM [Excel 8.0;HDR=Yes;database=C:\Temporary\My
Document\Abstractor_MRR_2004\cc_mrr_2004\Help\test.xls;].[Sheet1$A1:F100];
What I want to do is changing the fully directory to relative directory name
such as "\Help\test.xls".
Is there any method to do like that?
Thank you so much.
I have a question about "relative" directory name in append query.
I am using a following append query;
INSERT INTO AIS ( MRDID, MRDDOB)
SELECT [Sheet1$A1:F100].ChaseID, [Sheet1$A1:F100].MemberDOB
FROM [Excel 8.0;HDR=Yes;database=C:\Temporary\My
Document\Abstractor_MRR_2004\cc_mrr_2004\Help\test.xls;].[Sheet1$A1:F100];
What I want to do is changing the fully directory to relative directory name
such as "\Help\test.xls".
Is there any method to do like that?
Thank you so much.