Importing anExcel Spreedsheet

[Anthony Acri]

I looked at the import command on the File menu option.

It lets me import all the fields from the spreadsheet, or skip fields..
It created all the cell fields in the access db as text 255 characters

I would like to define a pre-defined table that matches the spreadsheet.

Then before importing the spreadsheet, delete all the rows in the table,
then import the spreadsheet
(like importing new data)

Can I just define the table first. Match the number of columns to the
number of cells I want to import

Can I just use the definition for each cell to what I want it to be in the
table?

I remember importing a text file before and was able to define a file to
indicate how long each field
is. Just don't remember what it was called and how I did it.

Any help is appreciated.

In a nutshell. Like to import a spreadsheet into a table. Maybe by using a
macro, have the process started. The database has to be cleaned out
everytime the file is imported.

This has to be transparent to the user

Any help is appreciated

Anthony

 

[Guest]

hi,
If it has to be transparent to the user why are you using
the import menu option?
I would look into linking the tile rather than importing.
access treats a linked excel file just like an access
table. once linked no further importing is needed. if the
range in the excel table varies, excel can to set up to
reset the range at before save event.
if you insist on importing then i would consider a macro
and the transferspread method. this can be assigned to a
button.