Importing from Excel

  • Thread starter Thread starter Geno
  • Start date Start date
G

Geno

I have an Excel spreadsheet with a column of dates,
numbers and difference. The difference is the result of
the number in a specific row minus the number in the
previous row (rowB number 100) minus rowA number 65) would
yield 35. This works fine in the excel spreadsheet. I
want to import this data into an Access database. When I
do I get all of the values but do not get the formula for
automatically calculating between row and previous row.
How can I get this? Can it be done in a table or do I need
a query? If so what would be the criteria for giving me
the difference between a number from a date and the number
from the previous date?

Thanks
 
Dear Geno:

There is no one order to the rows in a database. This is unlike a
spreadsheet where the rows come already numbered. Rather, you can
impose an order on the rows as you like.

So, if you have a definition of this order, then you can have a
reference to the "previous row" to retrieve the "number" you want to
subtract.

If you would post a simple SELECT query including an ORDER BY that
uniquely defines the order of the rows in your table, and specify the
name of the column on which this difference is calculated, I believe I
can post for you the necessary query for what you want.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts
 
Tom,

Thanks for the quick response but now I am throughly
confused.

I now have a simple table with the following rows
RowID (key/autonumber)
Date (date of entry in mm/dd/yyy format)
Number (general number)

I also have a simple form derived from this table and used
for entering new data.

Now I want a report that will give me Date, the date's
value and a calculated value derived from a date's number
and the previous date's number.

What would the query look like?

Thanks,

Geno
 
see the responses to "different value between each record" posted on
10/23/03 for several different examples of how to accomplish this.

--
HTH

Dale Fye


Tom,

Thanks for the quick response but now I am throughly
confused.

I now have a simple table with the following rows
RowID (key/autonumber)
Date (date of entry in mm/dd/yyy format)
Number (general number)

I also have a simple form derived from this table and used
for entering new data.

Now I want a report that will give me Date, the date's
value and a calculated value derived from a date's number
and the previous date's number.

What would the query look like?

Thanks,

Geno
 
Back
Top