Need Helpto Export Access Table to .txt type SDF

[Kishwar]

I need help in exporting MS Access table to .txt file in SDF as this file is to be used on some other platform where only text file standard data format i.e. with line return and eof can be read.
Earlier I was using Dbase table and used to pass the command


copy to file.txt type sdf and this used to do the trick for me.

Really need some some help as I'm stuck here as i was upgrading my project from foxpro to VB using Access tables

[Access_Blaster]

Hi Kishwar,

I tried to find a little info on your problem, heres what I found:
the link below is a thread about the subject.

http://www.microsoft.com/office/comm...xp=&sloc=en-us

For security reasons, newer versions of ACCESS will not import or export
(via TransferText) text files with nonstandard files extensions -- the only
file extensions that can be used for text files for ACCESS to import them
are ".txt", ".csv", ".tab", and ".asc". To handle a ".sdf" file extension,
see these Knowledge Base articles:

ACC2000: Importing or Linking a Text File Fails for a File That Does Not
Have a Valid File Name Extension
http://support.microsoft.com/default.aspx?id=304206

ACC2000: "Can't Update. Database or Object Is Read-only" Error Message When
You Import or Export Files

ACC2000: How to Import a Text File That Has an Extension That Access Does
Not Recognize
http://support.microsoft.com/?id=306144
(The renaming of the file is the preferred method.)

[Kishwar]

Dear Access_Blaster

Thanx for your for your response, but i think i was not able to convey what i actually required.
Output file required is a fixed field width text file with .txt extension but having end of line and end of file markers.
I'm able to convert Access table to .txt format but minus eol and eof markers

Hope you may be able to shed some light on to it.

Thanx