I'm attempting to import a large .csv file into a table
and Access seems to be locking up.  Does anyone know what
the max file size access can handle inporting into a table?

I have a user that is importing a very large .txt file
into access.  When he imports it he receives a the
following error:  syntax error in create table stmt.
The data will not pull in, however I can pull it into

In a database, I have one table that allows a user to
create their user information, including a username and
password.  I have another table that merely allows a user
to enter their username and password, and I want to use

I want to import text from MS Word. All the files that I
need are in one folder. Instead of importing one file at a
time(there are big number of files), I would like to have
a routin that would loop through the folder and import all

Under "Get External Data/Link Tables", in the file types
list box, a ".txt" file is not an option for a type of
file to link to.  All it has is ODBC Data Sources and XML
files.  I know I've linked to text files in the past.  

I've just had to reinstall Access 97 (part of Office 97
pro) but find that the text import converter isn't
available when I select "File | Get External Data | Import"
- there's no text option under "files of type". How can I

Anyone offer help on an argument required for a
specifcation name?
Thank you.

I am running an application on Access 2000.
Is it possible to link to tables in another Access
database using VBasic dynamically, rather than using
the      

I know that this an odd question, but I have had a request
to  further develop an Access 97 application (front end &
backend) in Oracle Forms!! Oracle Forms would be accessing
common indexes and standing data in addition to existing

Is there a way to export a query or table to excel and make the excel file read-only?  If so, will it be possible to replace this excel file each time I export to it.

Is there a way to inmort all the forms contained in a
diffrent access database ? I would like to do this in one
step with no questions asked    maybe be able to do this
with a button an a form

I have an Excel spreadsheet that contains a column of
comments, some of which are quite long.  I have linked the
spreadsheet to an Access 2000 database.  Although the
Access linked definition specifies a memo field, the

I'm trying to export the query result to a Text file. It
saves with horizontal lines and pipe delimited lines
(vertical ). Though I do need the pipe delimited lines  
which separate the columns but how can I get away with the

In Access 2000 when I import or export a file the wizards
do not start.  After the file is selected, the
words 'Import text wizard' display in the lower right
corner of the Access window but the wizard does not

Can anyone offer any reference on connecting Access to a
AS400 system??
Anything would be welcome!
Jean