Newbe needs help with importing to exsiting table..

[r4eboxer]

Hello,
I don't have alot of experience with access or vba. I am trying to import
an excel spreadsheet into an exsiting table. I get an error that the import
has failed. I can insert into a new table. I am working on a network. I have
tried the import several ways, including trying to import the same table with
all the same values and fields and still it will not work. Do I need code to
do this? Please help as I have very little hair left.
Robin

 

[Ken Snell \(MVP\)]

You don't tell us what type of error you were told had occurred, and you
don't tell us the structure of the table nor of the spreadsheet.

Just guessing, a common problem with importing data to an existing table is
that the first field in the table is an autonumber field for the table's
primary key. That field does not exist as a column in the EXCEL spreadsheet.
Therefore, when Jet tries to do the import, the columns and fields do not
match by name or by data type, and the import can fail.

 

[Inabón Yunes]

I posted this in another group but here it goes...
I am trying to import a Paradox table that has only two text fields and
about 15 blob graphic records, 6 years work.
I am done with Paradox and am going to switch to Access.
The problem is that after importing all the tables, the one with the
pictures only imports the key fields. I loose all the pictures.
How can I import to Access ALL the fields including the pictures? I know it
can be done but just don't know how.
IY

 

[AnandaSim]

I posted this in another group but here it goes...
I am trying to import a Paradox table that has only two text fields and
about 15 blob graphic records, 6 years work.
I am done with Paradox and am going to switch to Access.

What version of Paradox are you coming from? Maybe you can extract the
graphic files from the BLOBs into the filesystem using Paradox first?

Note that Access is not efficient in storing graphic BLOBS - in fact
most databases are not good at that - it's preferable to leave the
graphic files on the filesystem and then render them using screen
forms referring to the filenames.

HTH
Ananda