How do I create a data base from an excel file?

I am trying to import a txt file which exceeds the 255 field limitation in Access.  How can I get around this?  Please explain in layman's terms (I understand Access but I am not a programmer ;)).  Thanks!

The question I am asking is, when one needs to move data,
field to cell by field to cell into a large spreadsheet
from Access 2000 to Excel 2000, is it better to link the
data or create a module like this one:

I wish to import an ancient PAragon database into Access
but the Wizard does not support this product.  Anyone out
there with experience or suggestions on this one
MAny thanks

I have an Excel file that I would like to import into Access.  The Excel
file has a column with last names with the email addresses hyperlinked in
the text.  I would like to retain this information to Access or have it
split into another column.  I have tried to import and cut/paste ...

Every once in a while access changes all of fields in one
record to square boxes. It gives the
errorcode -1003 and the description of this error is:
Could not find field 'Description'. I don't have any

I am exporting my data to XML and I need to format the
date at YYYY/MM/DD.  I know you can select this option
when exporting to .TXT yet for XML there is no option.  I
have tried using the input mask to force the correct

Howdy, does anyone know how to create a tab delimited
export from Access?

I am encountering what appears to be a ODBC timeout when
linking to an Oracle Database. I have found in other
newsgroups that others have had the same thing happen when
connecting to mySQL or other backend ODBC connected

This message is continued from the same topic discussed
starting on Nov 19th and 20th by bcollier.
I got the issue on table names, thanks.  The problem is
(seems) more complex however.  When I use the method

I am creating a utility that allows users to restore
corrupt mdb files. To accomplish this, I create a new,
blank database and import all objects from the corrupted
database to the blank database. All this is done in vba

Whenever, I run this error happen I do not know what
wrong , please advice.
The error is: "Run time error 3027 - Can not update.
Database or Object is read only."

I have created a database and have another one with
similar fields but not all alike that was used in the
past.  What I need to do is move the data from the old db
to my new db.

In Access XP, when trying to set up an export
specification, I can't seem to find how to set the SKIP
COLUMN in the specs.  I have done this several time in
Access 2000 and there is a Skip Column field in

I have FEs and a BE DB all located at the following
path "\\server1\fldr1\fldr2\filename".  I split my DB into
FEs/BE because there are separate jobs the users want to
perform with the same data.  I then gave them each a