I've written some VBA code in MS Access to import a named
range from a Lotus spreadsheet into an Acess table.  This
works fine, with the following exception:  Access cannot
see all of the named ranges in the Lotus Spreadsheet.  

I am replacing a "house of cards" set of linked Excel
files with an Access data processing engine. There are
two sets of highly-formatted Excel files (one set for
input, the other set for output) that I want to read from

I am enterring data in a table through a form. Sometimes I enter a line
break by pressing enter or if a line break exists if I copy and paste data
from another document.
The problem is that these line breaks are recorded when the data is exported

I am importing an Excel spreadsheet Named Range into an
existing Access 97 table using the TransferSpreadsheet
Action.  I had my share of weird problems, but I seem to
have got to the point where everything will import

I need to export a table to excel, but not the field
names, as this excel file is then picked up from an SAP
application.  Does anyone know how to do this.  I see in
the help that even is you say no to field names they are

I’ve created a master form in Access to keep track of clients.  I then subform (from another table) to type notes/comments and date the notation.  I am able to look at the master form and see my notes and the date I created them.  My problem, when I merge to Word, I want to see ...

I have a function that is using SQL to update two tables
but I can't get my criteria to work so it is taking the
records from all the original tbls and updating to new
tables.  I.e. On a P.O. I have a cmd button to create the

I have a database which is used by about 30 users, all can input data into one table only, about 6 people can input data into all tables and 2 have permission to edit the design of the database.
The design of the database needs to be updated regularly (it is continually developing ...

Hi, i need to import data from 6 different text files into
6 different access tables.
The problem now is, there is a header at the top of each
text file, which includes the file name and date of the

I'm trying to import into a memo field text data which has line breaks (or new
lines, line feeds, or whatever you want to call them), but all those line
breaks get stripped out in the process.  And when I experiment, and try to
export data in memo fields which have line breaks, ...

I need to create an XML output file from an Access 2000
database using a DTD file that I have been given.
Is there any way to do this?
As far as I am aware you export a query to an XML output

First Excuse this msg if it comes up twice, I thought I
posted earlier but hasn't shown yet so I might have hit
cancel by mistake.  I would like to update two tables
based on information entered into another table via a

I am using vba to generate a crosstab query which then
outputs to an excell spreadsheet. An intermittenet problem
is that when I use the transferspreadsheet
(acSpreadsheetTypeExcel8), I get the error too many fields

I find that the export specification I have defined does not remember that I
checked and saved "Remember Field Names on First Row".  Therefore it is
useless to call this export from a Macro because it is missing the necessary
row headers.

I have a table with a memo field with data frequently >
255 characters.
My ultimate goal is to copy data from that table into a
word document table.