Using an Access database to link to SQL tables, from this reports are
run.  these reports have a number of fields and a rather large
comments section.  When the report is exported to Word, all
information can be viewed however, if exported to Excel at least half

       I'm importing from a text file using an SQL statement:
strSQL = "Insert INTO tblImport (Name, Address) " & _
 SELECT F1 As Name, F2 As Address " & _
 FROM " & strFilename & "#" & strExtension & " " & _

My db is split with the tables on the server.
As the data builds up, I'm wondering am I better having just one
back-end, or should I separate out some of the tables and create
several back-ends? It shouldn't make a difference to the front-end

I have 55 county files I need to import to a central db.  
I am looking for a way to pass the county name as a string
to the database name argument in the transferdatabase
macro.

Can not import *.dat file extensions through Access 97.  
It does not interrupt the carriage return character and
data is in one long stream.  Excel 97 does interpret the
*.dat files correctly, but I would like to automate the

I have an access table (first name, middle initial, last name).  I need to
export the table into a CSV file with " delimiters on EVERY field.  Access
is choosing not to include the quotes around empty fields.
In short, this throws off another program I have that imports the CSV file ...

My Access weekly contact report contains a memo field
describing the contact.  When I export the Access report
to Word, Word randomly and arbitrarily truncates the text
in the memo field on some of my contact instances.  The

I have created a macro with 'TransferText' action to
export the data from a query to a CSV file. How can I pass
the path for this CSV file dynamically at run time?
TIA,

i am importing data from an old database to a new 1. in
the new database i need an auto number that numbers the
products for a customer but on the change of the customer
i want the counter to reset to 0 and start counting

I have a routine that imports data from an Excel
spreadsheet which has relatively fiew records.  When the
export runs, I get something like 65,000+ records, 99.999%
of which have null values.

I have an Access 97 DB that isn't working with Windows
XP.  Is it advisable to convert straight to XP or convert
to Office 2000 then XP
Regards

I'm developing a database for a cardiolog, and I would like to insert the
wave files which I obtain by auscultation with an digital stethoscope, but I
would also have the possibility to hear and visualize (the sound graphic)
the wave files. Is there any possibility to do this with ...

I was wondering if there is any way to do this:
I have 2 macros that import an individual excel file into
the same table.  I want to be able to differentiate between
which excel file the record came from.

When I burn my access file to cd using adaptec cd creator 4, it becomes a read-only file.  How do I get it to let me work with the file after it is burned?

Hello! Please, does anybody know how to import MS Word (with .doc extension)
documents into Access 2000 database table?
do you know the VBA code that does it, or is there any link with article
describing it?