Relative Directory in Append Query

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top