Empty Rows

[Rob]

I would like to import into Access an Excell spreadsheet that has rows that
are either empty (left blank for presentation purposes) or have have formulas
in the rows.

How can I designate (or exclude) what I would like to import into access
from Excel.

Thanks

Rob

 

[Rob]

Dear Jeff:

Thanks for your quick response. I understand what you are saying but my dumb
question is if I am importing from Excel will an empty row come into Access
and because it is empty it will have no efffect on on queries. I am also
assuming that I can always run a delete query.

Thanks

Rob

 

[Jeff Boyce]

Rob

You may be confusing the purpose/use of a relational database with the
purpose/use you're making of Excel.

Access is not a spreadsheet. You do NOT use "blank rows for presentation
purposes" as rows of data in an Access table.

Access tables store data. Access forms and report present/display data,
with such "blank rows" and other formatting as you wish.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[Jeff Boyce]

Rob

In my experience, if I import an Excel spreadsheet, all of it imports ...
except the formulas! Again, Access tables aren't Excel spreadsheets.

An alternative to importing is to "link" to the data instead.

Regards

Jeff Boyce
Microsoft Office/Access MVP