I am having a problem that I see the answer to, but I don't understand what
it is that I need to do.  My apologies for being a little dense.
I need to replace a string in a memo field from the string to a soft return.
In looking at posts on this, the answer seems to be to do the ...

I am trying to set up a db using Office 2000 on a WinXP machine, importing
data from Excel.  I have Excel files with at least 5000 entries and about 75
column headings/Field names.  
I understand that the primary key needs to be set up for each individual,

I have to send a query in cvs format to my ;ogistics centre.With the help of
the forum i succeeded to do it :
DoCmd.TransferText acExportDelim, "qryDocExportSpecification", "QryDocs",
"QryDocs.csv"

I am a newbie access user and am trying to consolidate information at my
small business.  We are currently very Excel-centric and I'm trying to figure
out if Access would be a better fit.  
A critical element of a possible switch would be to be able to attach images

I know how to import e-mails into Access.  But I want to have Access to query
itself and send an e-mail.  For example...
My master list is..
Jon Doe

I have a excel file that in on an http://east.com/Census/Master.xls but when
I try to link or import I get... just an FYI I have VPN
The wizard is unable to access the file
'http://east.com/Census/Master.xls'. Please check that the file exists and

I have a data base containg my results,I need to run a query/report i need to
export the results into an excel speadsheet which already has the defined
fields.
Is this possible? If so how? I am quite new to access, but learning quickly

How do I get access to automatically import a file when it is opened?

I am importing data to a single table from multiple text files using a macro
and it is importing beautifully.
One piece of information is a required field but is not part of the file I
am importing.

I am trying to append data into a large table.  Currently the data is at
52000 lines.  When I tried to append the next Excel spreadsheet I get the
error " System Resource Exceeded"
Most of the searching I have done on Microsoft indicates that this is a

I've got an Access Project (ADP) with a SQL Server 2000 back-end that has
been running fine for years. Since installing SP3 the following is happening:
- In an Access form I can check a checkbox that is based on a bit field but
I cannot uncheck it. Once it is checked it remains ...

I  have this code to import comma delimited data from a website. This code
gets the data and I can display it in a message box , but I can't figure out
how to get the data (from ResponseText) into a table. Any ideas?
Thanks. Paco

Can be the above task done without docmd.transfertext; could be all the
processing done through a form: run, inputs /otputs?
Thanks a lot,
Dam

Access 2007
I have a database "Database3" it has 3 tables, Master, Importer of Record,
Customer.
Here is the question I would like to have a button on my main form that will

I need to export a date field to .csv format without the time and without
the "" quotes around the date.
I've tried FormatDateTime and Format and I get a set of "" quotes around the
date and I can't have that.