Export data from ADP file

[DorjiD]

Hello,
I want to create a tab delimited text file without any field qualifier
from a stored procedure which has 2 parameters. I'm trying to use
DoCmd.OutputTo method.

My problems:

1) By default access exports with comma delimited and double qoutation
as field qualifier. I want it to use tab delimited without field
qualifier

2)How to provide values for my stored procedure programatically without
the system dialouge popping up for user input

Thank you so much

Dorji

 

[aaron.kempf]

doesn't MSDE come with BCP?

do you have SQL Server client tools installed?

if you do; i'd just use BCP-- less horsing around

with bcp.exe you can just pass the whole SQL statement in and it's a
lot easier to deal with.

And you can do it all through a command prompt

-aaron

 

[DorjiD]

Hi Aaron,

Thanks for ur valuable comment. Since I wanted to make it a bit
user-friendly for users, I've decided to use the FileSystemObject.
Actually I was looking for something simple as a FileSpecification that
I'm so used to in MDB format. But FileSystemObject is not bad.

Dorji