Excel to Access Problem
 

First time post, so here goes. I am trying to convert a large Excel
spreadsheet (about 25k lines) to Access but I am running into a problem
because my spreadsheet varies in lengths. I am running a Macro in
Access and this is resulting in several blank Access entries because
the Excel spreadsheet can be longer or shorter depending on the report
I run. Is there anyway to make a formula that will make the cell not
register for Access if the value is false? Another solution would be
for Access to detect how many correct lines are in Excel and only
import that many lines, however this IS an Excel forum so I don't know
if there is a solution to that of which anyone knows about. If anyone
could help or needs more explanation of this issue please post.
Thanks!

-Brandon


--
ostate2007
------------------------------------------------------------------------
ostate2007's Profile: http://www.excelforum.com/member.php...o&userid=35875
View this thread: http://www.excelforum.com/showthread...hreadid=556649

Excel to Access Problem
 

Open Access, link to the workbook and use the appropriate worksheet as a
source table. You can then create a make table query and state the criteria
necessary to extract only the records you want placed into the new table.
--
Kevin Backmann


"ostate2007" wrote:


First time post, so here goes. I am trying to convert a large Excel
spreadsheet (about 25k lines) to Access but I am running into a problem
because my spreadsheet varies in lengths. I am running a Macro in
Access and this is resulting in several blank Access entries because
the Excel spreadsheet can be longer or shorter depending on the report
I run. Is there anyway to make a formula that will make the cell not
register for Access if the value is false? Another solution would be
for Access to detect how many correct lines are in Excel and only
import that many lines, however this IS an Excel forum so I don't know
if there is a solution to that of which anyone knows about. If anyone
could help or needs more explanation of this issue please post.
Thanks!

-Brandon


--
ostate2007
------------------------------------------------------------------------
ostate2007's Profile: http://www.excelforum.com/member.php...o&userid=35875
View this thread: http://www.excelforum.com/showthread...hreadid=556649