Excel to Access Problem

[ostate2007]

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

[Kevin B]

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
>
>