Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / New Users / September 2007

Tip: Looking for answers? Try searching our database.

Newbe needs help with importing to exsiting table..

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
r4eboxer - 28 Sep 2007 15:25 GMT
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) - 28 Sep 2007 16:04 GMT
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.
Signature


       Ken Snell
<MS ACCESS MVP>

> Hello,
>  I don't have alot of experience with access or vba. I am trying to import
[quoted text clipped - 8 lines]
> do this? Please help as I have very little hair left.
> Robin
Inabón Yunes - 28 Sep 2007 23:57 GMT
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
> Hello,
>  I don't have alot of experience with access or vba. I am trying to import
[quoted text clipped - 8 lines]
> do this? Please help as I have very little hair left.
> Robin
AnandaSim - 29 Sep 2007 07:43 GMT
On Sep 29, 8:57 am, "Inab?n Yunes" <Inab?nYu...@Naboria.com> wrote:
> 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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.