A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Can we import an Excel sheet to use as base for report?



 
 
Thread Tools Display Modes
  #1  
Old November 3rd, 2005, 01:05 PM
StargateFan
external usenet poster
 
Posts: n/a
Default Can we import an Excel sheet to use as base for report?

I don't know if this can even be done but I have an Excel spreadsheet
that I created that is ready to go already and is up to specs needed.
I'd like to do up a contact db in Access and was wondering if this
could be incorporated into it to form the report structure ... The
reason I don't use the Excel sheet is for the obvious reasons that an
A2K db would be easier to maintain in terms of the addresses, etc.,
themselves. Can this even be done?

I found the opposite with Access to Excel but not sure this is best
route to go as the A2K db may grow to be something more comprehensive
and I'd like to keep everything in one spot if that's the case. Tx.

  #2  
Old November 3rd, 2005, 01:39 PM
Jeff Boyce
external usenet poster
 
Posts: n/a
Default Can we import an Excel sheet to use as base for report?

If you'll check in on the tablesdbdesign newsgroup, you'll find a common
recommendation: Access is not a spreadsheet. Even though you've set up a
spreadsheet to be just what you want, you will find yourself (and Access)
working overtime to get simple things done if you simply import the Excel
structure into Access. ... and you won't be able to use some of the
features and functions that Access offers if you don't spend the time to
normalized your data structure.

I'm not sure how you've determined "that an A2K db would be easier to
maintain in terms of the addresses, etc." -- it sounds like you've already
got an Access db AND an Excel list.

JOPO (just one person's opinion)

Jeff Boyce
Office/Access MVP

"StargateFan" wrote in message
...
I don't know if this can even be done but I have an Excel spreadsheet
that I created that is ready to go already and is up to specs needed.
I'd like to do up a contact db in Access and was wondering if this
could be incorporated into it to form the report structure ... The
reason I don't use the Excel sheet is for the obvious reasons that an
A2K db would be easier to maintain in terms of the addresses, etc.,
themselves. Can this even be done?

I found the opposite with Access to Excel but not sure this is best
route to go as the A2K db may grow to be something more comprehensive
and I'd like to keep everything in one spot if that's the case. Tx.


  #3  
Old November 4th, 2005, 11:25 AM
StargateFan
external usenet poster
 
Posts: n/a
Default Can we import an Excel sheet to use as base for report?

On Thu, 3 Nov 2005 05:39:58 -0800, "Jeff Boyce"
-DISCARD_HYPHEN_TO_END wrote:

If you'll check in on the tablesdbdesign newsgroup, you'll find a common
recommendation: Access is not a spreadsheet. Even though you've set up a


Sorry, I wasn't clear. It's just that I happen to have a form that I
use that is done up in Excel. It's not because it's a spreadsheet,
it's because it's a "report", if you will, that I did up in Excel that
prints and show what I need in exactly the right size.

I don't need Access to be a spreadsheet, just to use the form.

Since we always have a 50/50 possibility, thought it wouldn't hurt to
ask g. I knew that the chances were only 50/50, so let me try again
to explain better to see if the answer is still no.

I designed a sheet with Excel because it's the easiest to work with
(do-able in Word but I can't stand the limitations in Word). Now I
thought of somehow taking a screenshot and "importing" that into
Access but it didn't make sense. I couldn't see how that would work
unless I use it as a picture in the report background (?). But since
I'm so new to Access and don't yet know what it can or can't do, not
sure this was best option. For all I know, all dimensions would be
lost in Access in the translation of the screenshot graphic.

So then I wondered if there was a way to "import" it, for lack of a
better word, into Access sort of like when we use Excel in Word.

Again, I really do understand that this might be a totally stupid idea
but I don't know until I ask and get the definitive answer.

Perhaps by asking, too, those of you who are much better at this than
I am as you've had tons of experience, might know of a better way to
do this.

I spent several days finetuning the Excel sheet and now I get
flawlessly sized custom pages for my Daytimer (since Daytimer just
doesn't carry the format I needed, I had to come up with my own).

I'm going to try taking this one step further by creating a db for a
contacts list/address list that I've been meaning to create forever
g, but it would be nice if I could use my existing Excel sheet esp.
in order to keep everything all in one place.

But, if it can't be done, can't be done. I just need a confirmation
one way or the other.

Though I've developed in Filmaker Pro for a number of years as a
hobbyist, Access is so completely different I'm still at the at-sea
stage. And I'd like to do this in A2K rather than FMP because I need
to learn this app for work purposes. I already can create to a great
degree in FMP and it's a super program, but the query function in A2K
is exactly what I need for some db ideas I have.

Thanks. D

spreadsheet to be just what you want, you will find yourself (and Access)
working overtime to get simple things done if you simply import the Excel
structure into Access. ... and you won't be able to use some of the
features and functions that Access offers if you don't spend the time to
normalized your data structure.

I'm not sure how you've determined "that an A2K db would be easier to
maintain in terms of the addresses, etc." -- it sounds like you've already
got an Access db AND an Excel list.


No,actually g. Not yet. I don't have either. Just getting started
on this project; but I always try to check with experts first - as in
this case - before I go off in the wrong direction unknowingly. g

JOPO (just one person's opinion)

Jeff Boyce
Office/Access MVP

"StargateFan" wrote in message
.. .
I don't know if this can even be done but I have an Excel spreadsheet
that I created that is ready to go already and is up to specs needed.
I'd like to do up a contact db in Access and was wondering if this
could be incorporated into it to form the report structure ... The
reason I don't use the Excel sheet is for the obvious reasons that an
A2K db would be easier to maintain in terms of the addresses, etc.,
themselves. Can this even be done?

I found the opposite with Access to Excel but not sure this is best
route to go as the A2K db may grow to be something more comprehensive
and I'd like to keep everything in one spot if that's the case. Tx.


  #4  
Old November 4th, 2005, 12:54 PM
Jeff Boyce
external usenet poster
 
Posts: n/a
Default Can we import an Excel sheet to use as base for report?

So, if I understand, you want to use an existing Excel spreadsheet/layout to
display data from Access. Yes you can.

You'll need to study up on how to export data out of Access into Excel, or
how to run a query from Excel against data stored in Access.

--
Regards

Jeff Boyce
Office/Access MVP

"StargateFan" wrote in message
...
On Thu, 3 Nov 2005 05:39:58 -0800, "Jeff Boyce"
-DISCARD_HYPHEN_TO_END wrote:

If you'll check in on the tablesdbdesign newsgroup, you'll find a common
recommendation: Access is not a spreadsheet. Even though you've set up

a

Sorry, I wasn't clear. It's just that I happen to have a form that I
use that is done up in Excel. It's not because it's a spreadsheet,
it's because it's a "report", if you will, that I did up in Excel that
prints and show what I need in exactly the right size.

I don't need Access to be a spreadsheet, just to use the form.

Since we always have a 50/50 possibility, thought it wouldn't hurt to
ask g. I knew that the chances were only 50/50, so let me try again
to explain better to see if the answer is still no.

I designed a sheet with Excel because it's the easiest to work with
(do-able in Word but I can't stand the limitations in Word). Now I
thought of somehow taking a screenshot and "importing" that into
Access but it didn't make sense. I couldn't see how that would work
unless I use it as a picture in the report background (?). But since
I'm so new to Access and don't yet know what it can or can't do, not
sure this was best option. For all I know, all dimensions would be
lost in Access in the translation of the screenshot graphic.

So then I wondered if there was a way to "import" it, for lack of a
better word, into Access sort of like when we use Excel in Word.

Again, I really do understand that this might be a totally stupid idea
but I don't know until I ask and get the definitive answer.

Perhaps by asking, too, those of you who are much better at this than
I am as you've had tons of experience, might know of a better way to
do this.

I spent several days finetuning the Excel sheet and now I get
flawlessly sized custom pages for my Daytimer (since Daytimer just
doesn't carry the format I needed, I had to come up with my own).

I'm going to try taking this one step further by creating a db for a
contacts list/address list that I've been meaning to create forever
g, but it would be nice if I could use my existing Excel sheet esp.
in order to keep everything all in one place.

But, if it can't be done, can't be done. I just need a confirmation
one way or the other.

Though I've developed in Filmaker Pro for a number of years as a
hobbyist, Access is so completely different I'm still at the at-sea
stage. And I'd like to do this in A2K rather than FMP because I need
to learn this app for work purposes. I already can create to a great
degree in FMP and it's a super program, but the query function in A2K
is exactly what I need for some db ideas I have.

Thanks. D

spreadsheet to be just what you want, you will find yourself (and Access)
working overtime to get simple things done if you simply import the Excel
structure into Access. ... and you won't be able to use some of the
features and functions that Access offers if you don't spend the time to
normalized your data structure.

I'm not sure how you've determined "that an A2K db would be easier to
maintain in terms of the addresses, etc." -- it sounds like you've

already
got an Access db AND an Excel list.


No,actually g. Not yet. I don't have either. Just getting started
on this project; but I always try to check with experts first - as in
this case - before I go off in the wrong direction unknowingly. g

JOPO (just one person's opinion)

Jeff Boyce
Office/Access MVP

"StargateFan" wrote in message
.. .
I don't know if this can even be done but I have an Excel spreadsheet
that I created that is ready to go already and is up to specs needed.
I'd like to do up a contact db in Access and was wondering if this
could be incorporated into it to form the report structure ... The
reason I don't use the Excel sheet is for the obvious reasons that an
A2K db would be easier to maintain in terms of the addresses, etc.,
themselves. Can this even be done?

I found the opposite with Access to Excel but not sure this is best
route to go as the A2K db may grow to be something more comprehensive
and I'd like to keep everything in one spot if that's the case. Tx.



  #5  
Old November 4th, 2005, 01:19 PM
StargateFan
external usenet poster
 
Posts: n/a
Default Can we import an Excel sheet to use as base for report?

On Fri, 4 Nov 2005 04:54:50 -0800, "Jeff Boyce"
-DISCARD_HYPHEN_TO_END wrote:

So, if I understand, you want to use an existing Excel spreadsheet/layout to
display data from Access. Yes you can.


Yes, but not in that direction.

You'll need to study up on how to export data out of Access into Excel, or
how to run a query from Excel against data stored in Access.


Ah, that's what I was afraid of. As I said, I had found Access to
Excel, but not Excel to Access. Doesn't look like what I want to do
can be done. Fair enough.

Again, I'm a real newbie so I don't know what Access can and can't do.
So it can't have an Excel structure imported into it for use. I'll
just have to live with that and figure out how to do the same type of
report from within Access. sigh It took me long enough to
fine-tune the Excel one. I'll keep the Excel sheets for ease of
transporting around on floppy. Every job has Excel but not all have
Access, so for the rest of this project, having it at home on Access
is not a problem.

Thanks so much for your help. This is how I'll learn by asking
questions.

Cheers. D

--
Regards

Jeff Boyce
Office/Access MVP

"StargateFan" wrote in message
.. .
On Thu, 3 Nov 2005 05:39:58 -0800, "Jeff Boyce"
-DISCARD_HYPHEN_TO_END wrote:

If you'll check in on the tablesdbdesign newsgroup, you'll find a common
recommendation: Access is not a spreadsheet. Even though you've set up

a

Sorry, I wasn't clear. It's just that I happen to have a form that I
use that is done up in Excel. It's not because it's a spreadsheet,
it's because it's a "report", if you will, that I did up in Excel that
prints and show what I need in exactly the right size.

I don't need Access to be a spreadsheet, just to use the form.

Since we always have a 50/50 possibility, thought it wouldn't hurt to
ask g. I knew that the chances were only 50/50, so let me try again
to explain better to see if the answer is still no.

I designed a sheet with Excel because it's the easiest to work with
(do-able in Word but I can't stand the limitations in Word). Now I
thought of somehow taking a screenshot and "importing" that into
Access but it didn't make sense. I couldn't see how that would work
unless I use it as a picture in the report background (?). But since
I'm so new to Access and don't yet know what it can or can't do, not
sure this was best option. For all I know, all dimensions would be
lost in Access in the translation of the screenshot graphic.

So then I wondered if there was a way to "import" it, for lack of a
better word, into Access sort of like when we use Excel in Word.

Again, I really do understand that this might be a totally stupid idea
but I don't know until I ask and get the definitive answer.

Perhaps by asking, too, those of you who are much better at this than
I am as you've had tons of experience, might know of a better way to
do this.

I spent several days finetuning the Excel sheet and now I get
flawlessly sized custom pages for my Daytimer (since Daytimer just
doesn't carry the format I needed, I had to come up with my own).

I'm going to try taking this one step further by creating a db for a
contacts list/address list that I've been meaning to create forever
g, but it would be nice if I could use my existing Excel sheet esp.
in order to keep everything all in one place.

But, if it can't be done, can't be done. I just need a confirmation
one way or the other.

Though I've developed in Filmaker Pro for a number of years as a
hobbyist, Access is so completely different I'm still at the at-sea
stage. And I'd like to do this in A2K rather than FMP because I need
to learn this app for work purposes. I already can create to a great
degree in FMP and it's a super program, but the query function in A2K
is exactly what I need for some db ideas I have.

Thanks. D

spreadsheet to be just what you want, you will find yourself (and Access)
working overtime to get simple things done if you simply import the Excel
structure into Access. ... and you won't be able to use some of the
features and functions that Access offers if you don't spend the time to
normalized your data structure.

I'm not sure how you've determined "that an A2K db would be easier to
maintain in terms of the addresses, etc." -- it sounds like you've

already
got an Access db AND an Excel list.


No,actually g. Not yet. I don't have either. Just getting started
on this project; but I always try to check with experts first - as in
this case - before I go off in the wrong direction unknowingly. g

JOPO (just one person's opinion)

Jeff Boyce
Office/Access MVP

"StargateFan" wrote in message
.. .
I don't know if this can even be done but I have an Excel spreadsheet
that I created that is ready to go already and is up to specs needed.
I'd like to do up a contact db in Access and was wondering if this
could be incorporated into it to form the report structure ... The
reason I don't use the Excel sheet is for the obvious reasons that an
A2K db would be easier to maintain in terms of the addresses, etc.,
themselves. Can this even be done?

I found the opposite with Access to Excel but not sure this is best
route to go as the A2K db may grow to be something more comprehensive
and I'd like to keep everything in one spot if that's the case. Tx.



  #6  
Old November 4th, 2005, 02:57 PM
Jeff Boyce
external usenet poster
 
Posts: n/a
Default Can we import an Excel sheet to use as base for report?

You may be writing it off too fast. The physical structure of the Excel
spreadsheet will not (as far as I know) import into Access. So what?

If you like the way the Excel ss looks, why not put the data from Access in
Excel. Store your data as Access data, and look it up (i.e., import it)
into Excel.

--
Regards

Jeff Boyce
Office/Access MVP

"StargateFan" wrote in message
...
On Fri, 4 Nov 2005 04:54:50 -0800, "Jeff Boyce"
-DISCARD_HYPHEN_TO_END wrote:

So, if I understand, you want to use an existing Excel spreadsheet/layout

to
display data from Access. Yes you can.


Yes, but not in that direction.

You'll need to study up on how to export data out of Access into Excel,

or
how to run a query from Excel against data stored in Access.


Ah, that's what I was afraid of. As I said, I had found Access to
Excel, but not Excel to Access. Doesn't look like what I want to do
can be done. Fair enough.

Again, I'm a real newbie so I don't know what Access can and can't do.
So it can't have an Excel structure imported into it for use. I'll
just have to live with that and figure out how to do the same type of
report from within Access. sigh It took me long enough to
fine-tune the Excel one. I'll keep the Excel sheets for ease of
transporting around on floppy. Every job has Excel but not all have
Access, so for the rest of this project, having it at home on Access
is not a problem.

Thanks so much for your help. This is how I'll learn by asking
questions.

Cheers. D

--
Regards

Jeff Boyce
Office/Access MVP

"StargateFan" wrote in message
.. .
On Thu, 3 Nov 2005 05:39:58 -0800, "Jeff Boyce"
-DISCARD_HYPHEN_TO_END wrote:

If you'll check in on the tablesdbdesign newsgroup, you'll find a

common
recommendation: Access is not a spreadsheet. Even though you've set

up
a

Sorry, I wasn't clear. It's just that I happen to have a form that I
use that is done up in Excel. It's not because it's a spreadsheet,
it's because it's a "report", if you will, that I did up in Excel that
prints and show what I need in exactly the right size.

I don't need Access to be a spreadsheet, just to use the form.

Since we always have a 50/50 possibility, thought it wouldn't hurt to
ask g. I knew that the chances were only 50/50, so let me try again
to explain better to see if the answer is still no.

I designed a sheet with Excel because it's the easiest to work with
(do-able in Word but I can't stand the limitations in Word). Now I
thought of somehow taking a screenshot and "importing" that into
Access but it didn't make sense. I couldn't see how that would work
unless I use it as a picture in the report background (?). But since
I'm so new to Access and don't yet know what it can or can't do, not
sure this was best option. For all I know, all dimensions would be
lost in Access in the translation of the screenshot graphic.

So then I wondered if there was a way to "import" it, for lack of a
better word, into Access sort of like when we use Excel in Word.

Again, I really do understand that this might be a totally stupid idea
but I don't know until I ask and get the definitive answer.

Perhaps by asking, too, those of you who are much better at this than
I am as you've had tons of experience, might know of a better way to
do this.

I spent several days finetuning the Excel sheet and now I get
flawlessly sized custom pages for my Daytimer (since Daytimer just
doesn't carry the format I needed, I had to come up with my own).

I'm going to try taking this one step further by creating a db for a
contacts list/address list that I've been meaning to create forever
g, but it would be nice if I could use my existing Excel sheet esp.
in order to keep everything all in one place.

But, if it can't be done, can't be done. I just need a confirmation
one way or the other.

Though I've developed in Filmaker Pro for a number of years as a
hobbyist, Access is so completely different I'm still at the at-sea
stage. And I'd like to do this in A2K rather than FMP because I need
to learn this app for work purposes. I already can create to a great
degree in FMP and it's a super program, but the query function in A2K
is exactly what I need for some db ideas I have.

Thanks. D

spreadsheet to be just what you want, you will find yourself (and

Access)
working overtime to get simple things done if you simply import the

Excel
structure into Access. ... and you won't be able to use some of the
features and functions that Access offers if you don't spend the time

to
normalized your data structure.

I'm not sure how you've determined "that an A2K db would be easier to
maintain in terms of the addresses, etc." -- it sounds like you've

already
got an Access db AND an Excel list.

No,actually g. Not yet. I don't have either. Just getting started
on this project; but I always try to check with experts first - as in
this case - before I go off in the wrong direction unknowingly. g

JOPO (just one person's opinion)

Jeff Boyce
Office/Access MVP

"StargateFan" wrote in message
.. .
I don't know if this can even be done but I have an Excel

spreadsheet
that I created that is ready to go already and is up to specs

needed.
I'd like to do up a contact db in Access and was wondering if this
could be incorporated into it to form the report structure ... The
reason I don't use the Excel sheet is for the obvious reasons that

an
A2K db would be easier to maintain in terms of the addresses, etc.,
themselves. Can this even be done?

I found the opposite with Access to Excel but not sure this is best
route to go as the A2K db may grow to be something more

comprehensive
and I'd like to keep everything in one spot if that's the case. Tx.



  #7  
Old November 4th, 2005, 03:40 PM
PC Datasheet
external usenet poster
 
Posts: n/a
Default Can we import an Excel sheet to use as base for report?

Access is ideal for a contact database! Access has a very comprehensive
ability to create whatever reports you would want. The database could be
built and then all the data you have in your Excel worksheet could be
imported into the database. I build low cost database applications for
customers if you need help. If you want, send me a copy of your worksheet
with a writeup of what you want the database to do and I will be glad to
give you a quote.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications

www.pcdatasheet.com

If you can't get the help you need in the newsgroup, I can help you for a
very reasonable fee.
Over 1000 Access users have come to me for help.
Need a month calendar or 7 day calendar? Contact me.


"StargateFan" wrote in message
...
I don't know if this can even be done but I have an Excel spreadsheet
that I created that is ready to go already and is up to specs needed.
I'd like to do up a contact db in Access and was wondering if this
could be incorporated into it to form the report structure ... The
reason I don't use the Excel sheet is for the obvious reasons that an
A2K db would be easier to maintain in terms of the addresses, etc.,
themselves. Can this even be done?

I found the opposite with Access to Excel but not sure this is best
route to go as the A2K db may grow to be something more comprehensive
and I'd like to keep everything in one spot if that's the case. Tx.



  #8  
Old November 4th, 2005, 05:49 PM
Vincent Johns
external usenet poster
 
Posts: n/a
Default Can we import an Excel sheet to use as base for report?

Jeff Boyce wrote:
You may be writing it off too fast. The physical structure of the Excel
spreadsheet will not (as far as I know) import into Access. So what?

If you like the way the Excel ss looks, why not put the data from Access in
Excel. Store your data as Access data, and look it up (i.e., import it)
into Excel.


Or, if you REALLY don't like the idea of keeping the Excel file around
to use for displaying your Access data, you could make a screen shot of
your Excel form and paste that onto an Access Form or Access Report, on
top of which you can place Access controls (e.g., list boxes) that
display the data you want to see.

Incidentally, you can easily import an Excel table (the kind you can
look at on the screen) into Access. What you can't import easily is the
structure of the interrelated formulas in Excel; those are represented
in Access by different means. But I'm guessing that you don't need to
do anything like that, that you have stuff like lists of names and
addresses and dates and meeting locations; these you could easily import
into Access if they're stored as Excel tables. Use File -- Get
External Data.

You have lots of possibilities here. (And if you're willing to write
some VBA code, you might even find that Word will do some or all of what
you want.)

-- Vincent Johns
Please feel free to quote anything I say here.


StargateFan wrote:
On Fri, 4 Nov 2005 04:54:50 -0800, "Jeff Boyce"
-DISCARD_HYPHEN_TO_END wrote:


So, if I understand, you want to use an existing Excel spreadsheet/layout to
display data from Access. Yes you can.



Yes, but not in that direction.


You'll need to study up on how to export data out of Access into Excel, or
how to run a query from Excel against data stored in Access.



Ah, that's what I was afraid of. As I said, I had found Access to
Excel, but not Excel to Access. Doesn't look like what I want to do
can be done. Fair enough.

Again, I'm a real newbie so I don't know what Access can and can't do.
So it can't have an Excel structure imported into it for use. I'll
just have to live with that and figure out how to do the same type of
report from within Access. sigh It took me long enough to
fine-tune the Excel one. I'll keep the Excel sheets for ease of
transporting around on floppy. Every job has Excel but not all have
Access, so for the rest of this project, having it at home on Access
is not a problem.

Thanks so much for your help. This is how I'll learn by asking
questions.

Cheers. D


--
Regards

Jeff Boyce
Office/Access MVP

"StargateFan" wrote in message
...

On Thu, 3 Nov 2005 05:39:58 -0800, "Jeff Boyce"
-DISCARD_HYPHEN_TO_END wrote:


If you'll check in on the tablesdbdesign newsgroup, you'll find a common
recommendation: Access is not a spreadsheet. Even though you've set up

a

Sorry, I wasn't clear. It's just that I happen to have a form that I
use that is done up in Excel. It's not because it's a spreadsheet,
it's because it's a "report", if you will, that I did up in Excel that
prints and show what I need in exactly the right size.

I don't need Access to be a spreadsheet, just to use the form.

Since we always have a 50/50 possibility, thought it wouldn't hurt to
ask g. I knew that the chances were only 50/50, so let me try again
to explain better to see if the answer is still no.

I designed a sheet with Excel because it's the easiest to work with
(do-able in Word but I can't stand the limitations in Word). Now I
thought of somehow taking a screenshot and "importing" that into
Access but it didn't make sense. I couldn't see how that would work
unless I use it as a picture in the report background (?). But since
I'm so new to Access and don't yet know what it can or can't do, not
sure this was best option. For all I know, all dimensions would be
lost in Access in the translation of the screenshot graphic.

So then I wondered if there was a way to "import" it, for lack of a
better word, into Access sort of like when we use Excel in Word.

Again, I really do understand that this might be a totally stupid idea
but I don't know until I ask and get the definitive answer.

Perhaps by asking, too, those of you who are much better at this than
I am as you've had tons of experience, might know of a better way to
do this.

I spent several days finetuning the Excel sheet and now I get
flawlessly sized custom pages for my Daytimer (since Daytimer just
doesn't carry the format I needed, I had to come up with my own).

I'm going to try taking this one step further by creating a db for a
contacts list/address list that I've been meaning to create forever
g, but it would be nice if I could use my existing Excel sheet esp.
in order to keep everything all in one place.

But, if it can't be done, can't be done. I just need a confirmation
one way or the other.

Though I've developed in Filmaker Pro for a number of years as a
hobbyist, Access is so completely different I'm still at the at-sea
stage. And I'd like to do this in A2K rather than FMP because I need
to learn this app for work purposes. I already can create to a great
degree in FMP and it's a super program, but the query function in A2K
is exactly what I need for some db ideas I have.

Thanks. D


spreadsheet to be just what you want, you will find yourself (and Access)
working overtime to get simple things done if you simply import the Excel
structure into Access. ... and you won't be able to use some of the
features and functions that Access offers if you don't spend the time to
normalized your data structure.

I'm not sure how you've determined "that an A2K db would be easier to
maintain in terms of the addresses, etc." -- it sounds like you've

already

got an Access db AND an Excel list.

No,actually g. Not yet. I don't have either. Just getting started
on this project; but I always try to check with experts first - as in
this case - before I go off in the wrong direction unknowingly. g

JOPO (just one person's opinion)

Jeff Boyce
Office/Access MVP

"StargateFan" wrote in message
om...

I don't know if this can even be done but I have an Excel spreadsheet
that I created that is ready to go already and is up to specs needed.
I'd like to do up a contact db in Access and was wondering if this
could be incorporated into it to form the report structure ... The
reason I don't use the Excel sheet is for the obvious reasons that an
A2K db would be easier to maintain in terms of the addresses, etc.,
themselves. Can this even be done?

I found the opposite with Access to Excel but not sure this is best
route to go as the A2K db may grow to be something more comprehensive
and I'd like to keep everything in one spot if that's the case. Tx.

  #9  
Old November 4th, 2005, 06:29 PM
John Marshall, MVP
external usenet poster
 
Posts: n/a
Default Can we import an Excel sheet to use as base for report?

So master santos, still chasing ambulances? These newsgroups were provided
by Microsoft so that users can obtain FREE peer to peer support. Sending a
quote does not sound like free support or are you planning on quoting
Shakespeare?

John... Visio MVP

"PC Datasheet" wrote in message
ink.net...
Access is ideal for a contact database! Access has a very comprehensive
ability to create whatever reports you would want. The database could be
built and then all the data you have in your Excel worksheet could be
imported into the database. I build low cost database applications for
customers if you need help. If you want, send me a copy of your worksheet
with a writeup of what you want the database to do and I will be glad to
give you a quote.


PC Datasheet


  #10  
Old November 4th, 2005, 07:32 PM
StopThisAdvertising
external usenet poster
 
Posts: n/a
Default Can we import an Excel sheet to use as base for report?


"PC Datasheet" schreef in bericht ink.net...
Access is ideal for a contact database! Access has a very comprehensive
ability to create whatever reports you would want. The database could be
built and then all the data you have in your Excel worksheet could be
imported into the database. I build low cost database applications for
customers if you need help. If you want, send me a copy of your worksheet
with a writeup of what you want the database to do and I will be glad to
give you a quote.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications

www.pcdatasheet.com

If you can't get the help you need in the newsgroup, I can help you for a
very reasonable fee.
Over 1000 Access users have come to me for help.
Need a month calendar or 7 day calendar? Contact me.


Steve, you lame coward, please go away ...

These 1000 (if at all a real figure..) is only the result of
-- 4 years abusing the newsgroups.
-- 4 years blatantly advertising and job hunting.

You only care about making money, and you act as if the groups are your private hunting ground.
So why would ANYBODY ever trust a person like you and hire you?
************************************************** ******

Explanation and more on this answer to Steve:
http://home.tiscali.nl/arracom/stopsteve.html

Arno R

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Import WisconsinIT Database Design 1 July 6th, 2005 07:40 PM
Getting Excel Data from One Sheet to Another.... Robin General Discussion 2 April 21st, 2005 01:15 PM
How can I import a website into my excel sheet automatically ever. Mohamed El Hefnawy General Discussion 2 April 13th, 2005 04:51 PM
How to select a cell from another work sheet base on a formula Jane Worksheet Functions 1 August 7th, 2004 12:11 AM
Opening Excel sheet with macro's on XP machines gives error Dhanashree Bhat Worksheet Functions 0 September 17th, 2003 07:02 AM


All times are GMT +1. The time now is 03:39 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.