I have a hyperlink field that I am using to link records
to images.  To make it short, what I need to do is replace
a character ($) in part of my field with the contents of
the ID field.  The result should be as follows:

I'm importing data from Excel to an existing Access
table.  Some of the fields in the Excel spreadsheet are
zero-length text strings (=""), and these fields are
formatted as text in my Access table.  But when I try to

I am exporting database file to text(tab delimited)
format, and it cuts off at two decimal degrees.  I need
all four decimal places.  How do I fix that?    For
exmaple, it shows, 2.32...I want 2.32456.

I have an application which is created using Access95 and
has a feature to import data from Excel 2002.
Question: Is there any limit on the number of records to
be imported because I had tested the feature and it works

I wish to transfer information from a Microsoft Access 2000 database located
on an externally hosted web server from which I only have FTP access to an
office based MS Access database.
I would like to know, if this is possible, is DOCMD.TRANSFERDATABASE the

I am using Access to extract data from a SQL Server table
and load it into Teradata.  This code was working
previously.  
I have about 99,000 rows to insert.  The query comes back

Can someone give me basic instructions to linking to
AS400?  Consider me a basic-intermediate user.
Thanks in advance for any help.

I created a report based from a query from an ODBC linked
table to an AS/400 query through client access.  Users
cannot run the report and they get a statement that the
ODBC connection failed.  If I try to refresh the link, I

I tried to export a table from SQL 2000 to Access 2002.
Everything works fine except data in one field can not be
exported. I did check datatype(char) and size and they are
all correct. There are several fields with same property

I am going to import a fixed width text file which is
prepared from other department's database. The text file
contains more than 40 fields that will be used as the raw
data for my database. What will be the best way to do it ?

I have an excel spreadsheet that is used to collect
information in a format completely different than the
format my access table is in. Think of my spreadsheet as
an application form where the user fills out information

My excel flat database is getting out of hand and really
needs to be exported into access.  (Should have done it
long ago).  Basically what I have is a field listing
several hundred employees who are assigned various assets

Field Options does not work when importing text files.
Have to go back and forth to the advance tab to set field
options. Clicking on field header does not work???? Is
this a bug???

I am creating a file that the ADP Unemployment Group,
UCeXpress Format will use. The data is coming from my
accounting system where I will use linked tables and
queries to format the dat per their specifications.

I have an Excel file I want to Link in Access but I need
to change the formatting (i.e. change a field from text
to number).  The import wizard does not give me the
option to do this like when I import a text file.  Anyone