I have a query I need to export into Excel, but due to limitations in the
system where the data from Excel will be pasted into, I need a new tab in the
spreadsheet (or a new spreadsheet) for each 50 records.  Is there some way of
accomplishing that using a macro or code ?  Any ...

I was wondering if anyone knows how to import information from various
different sources into access so I can spit out some matrix tracking reports.
Once I have that mastered I would like to put as much automation into it as I
can. Any suggestions? Some of the things I will be ...

I get error 3027 "No se puede actualizar. Base de datos u objeto de solo
lectura"
on the next VBA line:
DoCmd.TransferText acExportFixed, "Plantilla", "Tmp_Data", "TempFile.est",

here is the code that is failing. It works for me but not for my users. They
get a generic 'ODBC call failed' message. They are all set up with the driver
and system dsn and this used to work for them but it now fails. Is there any
way to modify the code to get a more specific ...

I have recently come across a software developed on MS-Access software which
allows the user to send and receive a set of pre-defined length of data into
a portable attendance logging device. This portable logging device is
interfaced to the PC using a serial port.

This is the thrid time I am trying to post a message.
After several searches, I cannot locate my previous two posts.
I am importing an Excel spreadsheet into a preexisting Access database.
However, the spreadsheet has two columns for addr1 and addr2, and the

Can someone help me please? I have a form in which I have placed a button
using the TransferText macro.
This is supposed to export a .txt/.csv. I have several queries which need to
be exported and they vary. Some are .csv some are .txt and some are tab

I am exporting data to a .txt file using TransferText with "Export Word for
Windows Merge" as type. this creates a schema.ini file with
col2 indx date
as a line in the file. This field indx holds a time in the format for

When I try to import any type of file, xls, txt, csv, etc Access gives me an
error message "You entered an expression that has an invalid reference to the
property |".  I re-installed the office suite several times without success.  
I am running Windows XP SP3 and MS Office 2002. ...

I'm linked to Foxpro for DOS 2.6 databases, using Access XP.  It links the
db's/tables fine, but only to display.  It won't let me enter data(or change
existing data) on a form, in the table, anywhere.
What am I doing wrong?

When I attempt to import a text file, I get the error message: "File
'C:\Documents and Settings\Administrator\My Documents\SALESPROD2.TXT' does
not contain data." It is a large text file, 2.14 GB. Before you say the
file's too large, I did check the Access specifications and ...

I am exporting my database to a CSV file and on the hyperlink field, the
export puts a # sign at the beginning and end of every record. Is there an
Update Query or Macro I can setup to remove the # character?
Thanks so much for your help!

I have successfully imported the linked tables, tables, forms, modules etc.
The linked tables come from an Oracle db. The problem I am having is with a
memo data type (in excess of 4096 bytes, some records look like War and Peace
excerpts) . When included on an Inner join, I ...

I am trying to import an excel spreadsheet into an existing Access table.  
There are approximatley 45000 records in the spreadsheet but Access is only
importing around 16000 of those records.  i have not expereinced this type of
problem previosuly.

Access 2003 SP1 XP SP2 OBDC Machine linking to some Visual Fox Pro tables
returns "The operation failed. There are too many indexes on table <name>.
Delete some of the indexes on the table and try the operation again. (Error
3626).