Import Excel file into Access

J

Jaime

I am having a problem in uploading an Excel file to Access. I distribute a
Excel to file to various person to enter information. All the files use the
same formats. When return I upload the file to Access the first goes in
without any problems. My problem starts when I try to upload the other files
and the application returns a Error in the upload. TO test the system I enter
the same file twice, the first time it enter correctly and reloading the same
file it gives me a error message. What can the problem be?
 
K

Klatuu

It would be helpful to know what the error is.
The most common problem here would be you have a field in the table you are
importing to that requires unique values. The first time you add the records
it works. The second time, the field already has the value in the Excel
sheet, so it cannot import it.
 
P

Pete D.

Could you share the full word for word error message so we can see what is
going on?
 
J

Jaime

it say:

An error ocurred trying to import file "file name and location". The file
was not imported.
 
P

Pete D.

Well sorry, that wasn't much help. Start with looking at your tables, do
they have keyfields and are you trying to duplicate those. Show us a little
sample data from one of the spreadsheets and the table design that you are
trying to import it to. Are you using a macro or any code, if so include
that info.
 
J

Jaime

This has been frustrating to be the least. The way I have setup the file is
the first tab contains a form that contains 100 fields of data. The person
fills out the form and after completing it returns the worksheet to me. This
step is repeated and done by 50 to 100 people. The second tab is a copy of
all the data fields from the first tab. I repeat the field names on the first
row and the second line contains the copies of the answers. The line does not
appear on the sheet. I put it there so you can see what I originally copy to
the second line.

Nombre del Evento Código asig. al Evento Fecha del Evento Fecha de
Evaluación Hora de Evaluación
Huracán Iván R1423 4/17/2008 4/18/2008 2:20 PM
=+'Formulario Evaluación Datos'!B9 =+'Formulario Evaluación
Datos'!d9 =+'Formulario Evaluación Datos'!e9 =+'Formulario Evaluación
Datos'!e9 =+'Formulario Evaluación Datos'!h9


The first time it is copy correctly but the second worksheet I try to copy
form I get the answer mention before. I have set up the columns on Excel and
Access files identically. I do not use code to copy anything (my next goal is
to learn this part). Any help is appreciated. If you want I can sent a copy
of my file for you to look over.
 
P

Pete D.

Yes, send it to me, I don't quite understand you said import and copy in
different messages are you trying to paste data into access or import it?
You can figure out my email from my address in this post. You said send
your file, which one, excel or access? I'll need both to sort it but change
the access file extension to something like .txt and I'll sort it on my
machine. Just tell me what it was originally.

pduffy211 AT cox DOT net

Pete
 
Top