I am trying to import a fixed width text file using the wizard into Access
2000 - each line is 884 characters wide, 690 lines in the file.  I have
defined 68 fields happily enough until I get to character 486 in the line,
when Access won't let me define any more fields.  This is ...

After reviewing Access Help on how to link a table from another Access file,
I am unsure of how to proceed.  Do I have to create a replica table of the
one I want to link to?...or do I just pull the desired table in on its own?
Then...do I have to set up relationships?

I cannot open more than one file.  When I open the second one it clears the
first one.  I am trying to import objects from one to another.  Help

Is it possible to export query results to a dbf file format in Access?  I am
using Access 2003 and am not familiar with dbf files, but creating a dbf file
from exported Access data is a requirement for this database.  I have
selected File--> Export and picked a file name and when ...

What is the best method for copying and pasting a recordset from one database
to another?
Thanks!

Originally I had an Excel import problem that doesn't allow me to specify
field options for any field other than the first.  I read the help file and
followed the advice to update Office.  Downloaded and installed an update and
service pack 2.  

I need to (regularly) translate up to 10,000 product names from English
to Chinese, then import the Chinese names into the Hong Kong version of
MYOB (popular accounting package).  Note you can (apparently) type the
chinese characters straight into MYOB and have them appear correctly ...

I designed a word template with some bookmarks and a word table with 7
cols(Prod.No, Descr, price, qty, colr, etc) .
I've also designed a userform with a list box to enable user select the
products.  This listbox is populated from a products table in access.

I had just downloaded a database.  However, it is comma delimited and I need
two fields to come in as one.  Access does not allow me to combine the 2
fields while I download.  Can anyone help please.  Thanks.
Irma

I have this query:
SELECT PHQ.SSN, PHQ.PHQDate, PHQ.PHQTOT
FROM PHQ
WHERE (((PHQ.SSN)=[whichSSN]));

When I export a table to a comma delimted text file using " as the text
identifier, I need to have empty columns display as "" in the text file.  
When I run through the export wizard, the repeating double quotes are shown -
but when I open the .txt file after the export, I do not ...

Is there a way to "automate" the writing of realtionships between imported
tables?
I have a situation where I need to re-import tables through an ODBC
connection into access a few times a day, and I need the relationships to be

Is there any way to detect if a file exists?
I want my database to display a command button only if file "export.csv"
exists on the server.

In 97, we used to export a table to a fixed width text file (using a saved
spec).  The file was always the same name with the extension ".ser" rather
than one of the conventional text file name extensions.  This worked fine.  
Now we are running the database in 2003 (still in 97 ...

My company wants to take all it's records in Access and convert them into a
usable contacts  database that we can all share in Outlook.  What is the
easiest & fastest way to do that without nay major programming or having to
purchase any additional software.