Okay, I imported successfully last month to an existing table.   This month,
problems.   I made my file a txt file, and through this found that I had a
extra column in my file.  Fixed it and now I am getting the error:
ORA-01013: user requested cancel of current operation.

I have seen some other posts on this subject, but none seem to quite match my
needs:
My .txt file holds dates in this format:  yyyy-mm-dd hh:mm
I have tried building several masks but cannot get it right and keep getting

I have configured the Access Options\AutoIndex om Import/Create to blank i.e.
no text is entered.
i restarted Access but when I use TransferSpreadSheet to import a Sheet the
Table is sorted in some order.... Not sure what order. I just need to remove

A internet advertising company had me export my microsoft outlook inbox to
them and now I am getting error messages for incoming e-mail. I am not able
to receive my e-mail since I did that. What can I do to fix this problem and
get my e-mail inbox back? I have microsoft outlook ...

I have 12 daily csv reports that have a autonumber added to a standard naming
convention.
Is there anyway of renaming these files from a database so that my normal
import spec works without having to manually amend the file names.

I need to create a report from an Access Database in a .doc version.  It
needs to include graphics.

Hi... it seems that Access is automatically deleting my expression values
that yield an undefined value (zero in the denominator) when I export to
Excel.  I get a message that x number or records have been deleted.  It
appears that there are now blank spaces in Excel where zeros ...

The above is an error message that I keep getting when trying to import a
certain set of data, whether it is in xls, xlsx, csv, or tab delimited format
-- even when I've saved the tab-delimited file in Notepad. If anyone can tell
me what this message means, I would greatly ...

I am creating a linked table to an Excel spreadsheet. Everything is fine with
one exception. Date/Time fields in Excel are created in Access as text
fields, which is OK other than Date/Time cells that have been amended in
Excel - change tracking is activated - display '#Num!' in ...

I made an error while defining the data type in a particular field in the
linked table, which is a .txt file.
Everything else is fine, but I said one field was a Number and in fact it is
Text so of course it does not display correctly in my Access table.

I don't know code so I'm trying to use the Import Wizard in Access to import
Excel Worksheet. I go to the Tables view of Access. I click on "New," Click
on "Import Table," Click "OK" the screen changes so that I may choose the
location of the file I want to Import. I set the ...

I am trying to import a worksheet from Excel.  The worksheet has 6 columns
of data and about 2700 rows.  The first column contains a 17 digit ID number.
When I import it into Access the original number 78020063061269800 turns
into 7.80200632418871E+16.  This is unusable to me.  ...

I've a table with text & number fields. The fields are appended to the table
from the query below (where the Sum fields have been formatted with leading
zeros using the format function).
Query looks good, table looks good, but export to Excel or txt...no good

I am hoping the Man of Steele is around and can help with this one.
I have taken his code, and tweaked it to work with Mysql.  It works
great.  It takes my tables and makes them DSNless, just as advertized.
Until now, that is all I needed to do.  All the tables from one DB, set

I am using Access 2002 and am using the Import Spreadsheet Wizard, I am able
to change the first column's field name and index within the field options
screen but I cannot amend the subsequent fields. Is there a fix or script I
can obtain to remove this problem?