What do I do next

A

Ayo

I get this error message when I tried to import a table: An error occurred
trying to import file ... The file was not imported. And access didn't say
what the problem is, how to I fix the problem?
 
M

Maurice

You need to provide just a little more info here. What kind of table are you
trying to import? Is it an Access table or another format. Give us some info
on the table and the importsteps you are taking...
 
A

Ayo

I was trying to import an excel file.

Maurice said:
You need to provide just a little more info here. What kind of table are you
trying to import? Is it an Access table or another format. Give us some info
on the table and the importsteps you are taking...
Click to expand...
 
F

fredg

I was trying to import an excel file.
Click to expand...

You really haven't given enough useful information.
Import the table from Excel how?
Using TransferSpreadsheet?
Using File + Get External data + Import?

Did you try simply selecting the data on the spreadsheet, Copy it,
open your database to the main database folder Tables , and Paste it?
or...
From your database click on File + Get External Data + Link.
Does that successfully link to your worksheet?
 
A

Ayo

I was using File + Get External data + Import

fredg said:
You really haven't given enough useful information.
Import the table from Excel how?
Using TransferSpreadsheet?
Using File + Get External data + Import?

Did you try simply selecting the data on the spreadsheet, Copy it,
open your database to the main database folder Tables , and Paste it?
or...
From your database click on File + Get External Data + Link.
Does that successfully link to your worksheet?
Click to expand...
 
M

Maurice

Ok,

We are getting there. Now for the excel source is the information on the
first sheet does it contain formulas etc.

Next try to describe the steps when you use the get external data -> import.
The wizard shows up, what steps do you take then...
 
A

Ayo

The er are no formulars.
I select the sheet
I acknowledge the first row is a row header
Error Message: The 1st row contains some data that can't be used for valid
Access field names. In these cases, the wizard will automatically assign
valid field names.
I assign primary keys of my own
 
M

Maurice

Clear,

Have you looked if the columnnames from within the excelsheet aren't
reserved words? Also try importing it without designating the primary key
during the wizardsteps (try that when the import is finished). How many
columns should be imported?
 
Top