importing excel into access

  • Thread starter Thread starter violinist
  • Start date Start date
V

violinist

Access 2007.
When trying to import excel spreadsheet in access I get this message:
| can't find the field '|' referred to in your program
 
I currently open a database in Access 2007, select External Data, choose the
Excel drop down menu. A dialgue box asks me to find the file, which I browse
to do. Then click okay and the statement I originally wrote about occurs.

I have done this operation thousands of times in Access 2003. Though the
boxes are different the basic process seems to be the same, but I cannot
manage to make it work. This is rather critical since I am putting together a
mailing list which needs the inquiry modules of Access to merge it and weed
out duplicates.

I hope you have an idea.
Violinist
 
First clear print area in excel OR name the range you are trying to import
and use that name for the import. If that doesn't work make sure the
fieldnames/Column headings don't have any access restricted items such as #
[] OR let accees add the field names.
 
why dont you just use the remove duplicates feature in excell before you
import the data?

Pete D. said:
First clear print area in excel OR name the range you are trying to import
and use that name for the import. If that doesn't work make sure the
fieldnames/Column headings don't have any access restricted items such as #
[] OR let accees add the field names.
violinist said:
I currently open a database in Access 2007, select External Data, choose
the
Excel drop down menu. A dialgue box asks me to find the file, which I
browse
to do. Then click okay and the statement I originally wrote about occurs.

I have done this operation thousands of times in Access 2003. Though the
boxes are different the basic process seems to be the same, but I cannot
manage to make it work. This is rather critical since I am putting
together a
mailing list which needs the inquiry modules of Access to merge it and
weed
out duplicates.

I hope you have an idea.
Violinist
Click to expand...
Click to expand...
 
You can sort duplicates in excel, but you cannot merge mailing lists or find
which names in one list do not exist in another.
Violinist

cheekyblue said:
why dont you just use the remove duplicates feature in excell before you
import the data?

Pete D. said:
First clear print area in excel OR name the range you are trying to import
and use that name for the import. If that doesn't work make sure the
fieldnames/Column headings don't have any access restricted items such as #
[] OR let accees add the field names.
violinist said:
I currently open a database in Access 2007, select External Data, choose
the
Excel drop down menu. A dialgue box asks me to find the file, which I
browse
to do. Then click okay and the statement I originally wrote about occurs.

I have done this operation thousands of times in Access 2003. Though the
boxes are different the basic process seems to be the same, but I cannot
manage to make it work. This is rather critical since I am putting
together a
mailing list which needs the inquiry modules of Access to merge it and
weed
out duplicates.

I hope you have an idea.
Violinist

:

What steps are you currently following?
--
Bob Larson

Tutorials at http://www.btabdevelopment.com

__________________________________


:

Access 2007.
When trying to import excel spreadsheet in access I get this message:
| can't find the field '|' referred to in your program
Click to expand...
Click to expand...
Click to expand...
 
Back
Top