Access 2003.  I am importing a comma-delimited text file into an existing
Access table.  When the import is complete I get the information dialog
saying:

For research and productivity purposes we have been entering and uploading pt
testing information in an Access db. It is not intended for use on the Web.
Recently we’ve joined a research Network that will utilize some of our data.
Instead of re-entering data, I would like to ...

an access application on a server is run
from two different computer.
On one of the machine it is working correctly
On the other a broken reference make the program stop.

Carriage return (Alt+del) in excel data in one cell is imported to small
aquare box into the place of carriage return. Some one have magic idea to
import same as excel?
Excal source data

This is what I have and It will not select the Columns. I must be missing
something?
Sub Format()
           ' Excel stuff

I have been importing excel data when I clean it up to match other data in my
access database. Recently, access shut down when I tried to perform the same
action. Is this a problem with Access or my data. How can I fix this? Help.

Any help would be greatly appreciated....
I have a report that I am creating to eventually export to a Text
File....the Text file has very specific character limits as it goes out to a
vendor who applies scripts and such dependent on the placement of certain

I am exporting my file as a .csv or .txt (tab delimited) for mail merge in
InDesign. I have entered 54 entries but there ends up being 67 entries when I
merge the file. One field is giving me problems on some entries but I can't
figure it out.

Docmd.Outputto is not working in Access 2002.  I'm trying to export query
results to a txt file.  I'm getting "not enough memory" errors when I have
the statement in VBA code.  statement is "docmd.outputto acOutputQuery,
"qryxyz", acFormatTXT, , False".  The query has an ...

I have an application with several linked tables of a SQL Server ODBC.
When I try to update one record only in one of tables, MSAccess shows a
message that other user is making changes to the same record and asks me to
copy this record to the clipboard.

I have an Access mdb file with exclusive file password. From Excel I attempt
to connect to the file, it produces Automation Error no -2147217843.
the code looks like this;
Dim cn As New ADODB.Connection

I tried to sel;ect different non related parts of text. In word 2003 this
function was provided by the mouse+Ctrl key action. But now I have to deal
with word 2000 and this combination doesn't work.
What's the solution?

I have a table in my db for employees that has First_Name, Last_Name and
EmployeeID fields. I have an expenses table that has the details for the
expenses but only the EmployeeID.
I imported an excel spreadsheet which is now a table with EmployeeName, and

I have a data table consisting of 10,000 rows with various row headers and
numerical scores, 0 through 10.  All the fields containing scores are
formatted as "Number"
Problem is that I'd like, at times, to use the "NA" convention (or some