This was working before I migrated to XP. I try to output
two reports under a .snp format on my c drive but only
the first one is exported.  If I run manually the
autoexec, it works.

I do import and export a text file is OK.
But when I created a specification file then where are
they stored? Is it in register file or in .mdb file?
Thank you for any suggestion.

I'm importing a column of data with a reference number in it from Excel to
Access 2000 using a macro.  The first few reference numbers in the excel
sheet are purely numbers but further down I have reference numbers with
letters in them.

A Coworker of mine painstakingly created an import spec
for a complex fixed length file and I wanted to use it for
a db of my own.  I can't figure out where the spec info is
stored.

Could you help me how to export a table to a text file?
I do export a table to a text file, when in the
specification I do not want export a first column, how can
I do that?

Dear Group:
I need to get some data from an SQL Server database.  The
administrator says that he will provide it to me as an XML
file for import into my Access 2002 database.  He has

Can someone please help!!  I have multiple (~60) .txt
files that are updated on a daily basis that I would like
to have linked to an Access table.
The issue is, the .txt files are numerous and new files

 I'm using Access 2003 and I'm trying to link to DBF
tables from Visual FoxPro.  However, I get error
3274 "External table is not in the expected format".  I
would really appreciate your help.

We are trying to develop a simple interface for an oracle 8i database, and
are considering access.
The interface will be used to set some data warehouse parameters and
settings.  The warehouse is loaded from another oracle data base but we need

I am trying to import data from an Excel file to Access
table by using an update query (Excel file is linked).
Everything is going right except one column.
In Excel it contains numbers from 1 To 9999 and sometimes

I am working in Access 2000 and have the following
problem.
I want to get a string with all the directories on one
drive (v:) to use in a listbox. I already tried to get it

How can I import data from DAT file? Currently I open the
DAT file with Notepad and then save it as TXT file. But
now, the DAT file is too big -about 500MB. After I opened
the DAT, I can't save it in TXT format any more because

Hy,
I have moved the tables from my Access database to a SQL
Server (keeping the queries, the forms, the report and the
cod at each user’s PC).

What is the easiest way to pull email out into a semi-
colon denominated list?

I need to link an Access97 front end to an XP back end on our network to
read-only data.
I have tried ADO and ODBC with an appropriate driver but get the error:
Unrecognised DB format