Problem Importing or Linking Excel Spread

[Guest]

I have a spreadsheet in excel that seems to be formatted like literally
hundreds of spreadsheets I have imported. When I try to import or link this
spreadsheet, I get an error telling me the wizard can't access the
spreadsheet - make sure it exists or is in the proper format. It definitely
exists.

A free virtual pocket protector for the person with the best answer!

 

['69 Camaro]

Hi.

When I try to import or link this
spreadsheet, I get an error telling me the wizard can't access the
spreadsheet - make sure it exists or is in the proper format. It
definitely
exists.

The spreadsheet may be corrupted. If not, convert the XLS file to a CSV
file, and then attempt to import the new CSV file. You will receive an
error message if the spreadsheet cannot be successfully imported, and an
import errors table will be created showing which columns in which rows
weren't imported, and why.

A free virtual pocket protector for the person with the best answer!

Do they come in blue or with the Oracle logo on them? ;-)

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

[Guest]

Spreadsheets in BIF format have the same XLS extension
and you don't get any conversion message when you open
the file -- it's a silent conversion, you have no easy way
of knowing if it is in BIF format or normal XLS format.

BIF is Binary Interchange Format, the old open format for
spreadsheet data.

Access wizards export XLS data in BIF, but the Jet XLS
IISAM imports/exports only in native XLS format.

(david)