Splitting Database and using Excel as a front.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to split my database and have the front end Excel for mulitple users.
How do I make Excel the front end?
 
Why make it so difficult for yourself?

Access is the front end and get users to copy the file on to their own hard
drives.
 
I have just seen your previous post. Customers eh? who needs them! :-)

The problem with that kind of attitude is that he/she is not developing
his/her staff in terms of career development and learning. rant over.

You *can* link an excel spreadsheet to a table using the "import" function.
On a network I believe you can make a spreadsheet a shared file. This means
multiple users can open the same spreadsheet but what it would mean for data
entry I wouldn't know.

It is worth a try.
 
Thanks, I've tried everything to link multiple spreadsheets to one table in
Access. I give up. I'm telling my management it can't be done and just the
thought of having Excel as a front end kills me. I had to try because I was
told too. Gotta love the Corporate Life. Thanks again.
 
The only way to do it is to have multiple tables each with their own
spreadsheet and then use a UNION query to join them.

How many users though?
 
There will be 10 users. A union query huh? What is the proccess to make a
union query? I will look at the help munu too.
 
Ching, Ching!!! :-)

Are you sure there will be ten users only?

Create duplicate tables each with their own Excel link and use a union query
to create a master query.

SELECT [FIELD1], [FIELD2]
From Table1

UNION SELECT [FIELD1], [FIELD2]
From Table2

etc ....

UNION SELECT [FIELD1], [FIELD2]
From Table10;


The problem with Excel is how users will be entering information. Simply
entering into rows or through a form? You are better off asking in the Excel
forum for that one.
 
okay I'm not sure if there will be only 10 users but I do know there are only
going to be 10 sites. One Spreadsheet per site. Thank you for your help. Off
to build a query.

scubadiver said:
Ching, Ching!!! :-)

Are you sure there will be ten users only?

Create duplicate tables each with their own Excel link and use a union query
to create a master query.

SELECT [FIELD1], [FIELD2]
From Table1

UNION SELECT [FIELD1], [FIELD2]
From Table2

etc ....

UNION SELECT [FIELD1], [FIELD2]
From Table10;


The problem with Excel is how users will be entering information. Simply
entering into rows or through a form? You are better off asking in the Excel
forum for that one.


--
"Loose Change 2nd Edition" has been seen by almost 7 million people on
Google video


Marc said:
There will be 10 users. A union query huh? What is the proccess to make a
union query? I will look at the help munu too.
Click to expand...
Click to expand...
 
It's working perfectly...Thanks. Now I have a ReceivedDate Field in my query.
I wanted a criteria to search by date, how would I write that in the query?

scubadiver said:
Ching, Ching!!! :-)

Are you sure there will be ten users only?

Create duplicate tables each with their own Excel link and use a union query
to create a master query.

SELECT [FIELD1], [FIELD2]
From Table1

UNION SELECT [FIELD1], [FIELD2]
From Table2

etc ....

UNION SELECT [FIELD1], [FIELD2]
From Table10;


The problem with Excel is how users will be entering information. Simply
entering into rows or through a form? You are better off asking in the Excel
forum for that one.


--
"Loose Change 2nd Edition" has been seen by almost 7 million people on
Google video


Marc said:
There will be 10 users. A union query huh? What is the proccess to make a
union query? I will look at the help munu too.
Click to expand...
Click to expand...
 
The one thing I forgot to ask is whether you have sorted out your unique
record identifiers.

With the date criteria what I normally do is create a form and insert an
unbound text box or combo box and reference the form name in the criteria row
of the date field in the query:

[forms]![form name]![field name]


Marc said:
It's working perfectly...Thanks. Now I have a ReceivedDate Field in my query.
I wanted a criteria to search by date, how would I write that in the query?

scubadiver said:
Ching, Ching!!! :-)

Are you sure there will be ten users only?

Create duplicate tables each with their own Excel link and use a union query
to create a master query.

SELECT [FIELD1], [FIELD2]
From Table1

UNION SELECT [FIELD1], [FIELD2]
From Table2

etc ....

UNION SELECT [FIELD1], [FIELD2]
From Table10;


The problem with Excel is how users will be entering information. Simply
entering into rows or through a form? You are better off asking in the Excel
forum for that one.


--
"Loose Change 2nd Edition" has been seen by almost 7 million people on
Google video


Marc said:
There will be 10 users. A union query huh? What is the proccess to make a
union query? I will look at the help munu too.

:


The only way to do it is to have multiple tables each with their own
spreadsheet and then use a UNION query to join them.

How many users though?

--
"Loose Change 2nd Edition" has been seen by almost 7 million people on
Google video


:

Thanks, I've tried everything to link multiple spreadsheets to one table in
Access. I give up. I'm telling my management it can't be done and just the
thought of having Excel as a front end kills me. I had to try because I was
told too. Gotta love the Corporate Life. Thanks again.

:


I have just seen your previous post. Customers eh? who needs them! :-)

The problem with that kind of attitude is that he/she is not developing
his/her staff in terms of career development and learning. rant over.

You *can* link an excel spreadsheet to a table using the "import" function.
On a network I believe you can make a spreadsheet a shared file. This means
multiple users can open the same spreadsheet but what it would mean for data
entry I wouldn't know.

It is worth a try.



--
"Loose Change 2nd Edition" has been seen by almost 7 million people on
Google video


:

I want to split my database and have the front end Excel for mulitple users.
How do I make Excel the front end?
Click to expand...
Click to expand...
Click to expand...
 
At first I had a unique identifier then I took it out, because I would have
10 diferrent spreadsheet that would have all the same unique identifier. I'm
sure there is a way to get the spreadsheet to have all different unique
identifiers but not sure how to do that. Or is there a way for Access to do
that? It's propably not a good idea to take out the unique identifiers, is it?

Thanks for your help again.

scubadiver said:
The one thing I forgot to ask is whether you have sorted out your unique
record identifiers.

With the date criteria what I normally do is create a form and insert an
unbound text box or combo box and reference the form name in the criteria row
of the date field in the query:

[forms]![form name]![field name]


Marc said:
It's working perfectly...Thanks. Now I have a ReceivedDate Field in my query.
I wanted a criteria to search by date, how would I write that in the query?

scubadiver said:
Ching, Ching!!! :-)

Are you sure there will be ten users only?

Create duplicate tables each with their own Excel link and use a union query
to create a master query.

SELECT [FIELD1], [FIELD2]
From Table1

UNION SELECT [FIELD1], [FIELD2]
From Table2

etc ....

UNION SELECT [FIELD1], [FIELD2]
From Table10;


The problem with Excel is how users will be entering information. Simply
entering into rows or through a form? You are better off asking in the Excel
forum for that one.


--
"Loose Change 2nd Edition" has been seen by almost 7 million people on
Google video


:

There will be 10 users. A union query huh? What is the proccess to make a
union query? I will look at the help munu too.

:


The only way to do it is to have multiple tables each with their own
spreadsheet and then use a UNION query to join them.

How many users though?

--
"Loose Change 2nd Edition" has been seen by almost 7 million people on
Google video


:

Thanks, I've tried everything to link multiple spreadsheets to one table in
Access. I give up. I'm telling my management it can't be done and just the
thought of having Excel as a front end kills me. I had to try because I was
told too. Gotta love the Corporate Life. Thanks again.

:


I have just seen your previous post. Customers eh? who needs them! :-)

The problem with that kind of attitude is that he/she is not developing
his/her staff in terms of career development and learning. rant over.

You *can* link an excel spreadsheet to a table using the "import" function.
On a network I believe you can make a spreadsheet a shared file. This means
multiple users can open the same spreadsheet but what it would mean for data
entry I wouldn't know.

It is worth a try.



--
"Loose Change 2nd Edition" has been seen by almost 7 million people on
Google video


:

I want to split my database and have the front end Excel for mulitple users.
How do I make Excel the front end?
Click to expand...
Click to expand...
Click to expand...
 
It would better to keep them in. Since each site is separate can't you have
a site prefix for each spreadsheet? A primary key doesn't have to be a number.



Marc said:
At first I had a unique identifier then I took it out, because I would have
10 diferrent spreadsheet that would have all the same unique identifier. I'm
sure there is a way to get the spreadsheet to have all different unique
identifiers but not sure how to do that. Or is there a way for Access to do
that? It's propably not a good idea to take out the unique identifiers, is it?

Thanks for your help again.

scubadiver said:
The one thing I forgot to ask is whether you have sorted out your unique
record identifiers.

With the date criteria what I normally do is create a form and insert an
unbound text box or combo box and reference the form name in the criteria row
of the date field in the query:

[forms]![form name]![field name]


Marc said:
It's working perfectly...Thanks. Now I have a ReceivedDate Field in my query.
I wanted a criteria to search by date, how would I write that in the query?

:


Ching, Ching!!! :-)

Are you sure there will be ten users only?

Create duplicate tables each with their own Excel link and use a union query
to create a master query.

SELECT [FIELD1], [FIELD2]
From Table1

UNION SELECT [FIELD1], [FIELD2]
From Table2

etc ....

UNION SELECT [FIELD1], [FIELD2]
From Table10;


The problem with Excel is how users will be entering information. Simply
entering into rows or through a form? You are better off asking in the Excel
forum for that one.


--
"Loose Change 2nd Edition" has been seen by almost 7 million people on
Google video


:

There will be 10 users. A union query huh? What is the proccess to make a
union query? I will look at the help munu too.

:


The only way to do it is to have multiple tables each with their own
spreadsheet and then use a UNION query to join them.

How many users though?

--
"Loose Change 2nd Edition" has been seen by almost 7 million people on
Google video


:

Thanks, I've tried everything to link multiple spreadsheets to one table in
Access. I give up. I'm telling my management it can't be done and just the
thought of having Excel as a front end kills me. I had to try because I was
told too. Gotta love the Corporate Life. Thanks again.

:


I have just seen your previous post. Customers eh? who needs them! :-)

The problem with that kind of attitude is that he/she is not developing
his/her staff in terms of career development and learning. rant over.

You *can* link an excel spreadsheet to a table using the "import" function.
On a network I believe you can make a spreadsheet a shared file. This means
multiple users can open the same spreadsheet but what it would mean for data
entry I wouldn't know.

It is worth a try.



--
"Loose Change 2nd Edition" has been seen by almost 7 million people on
Google video


:

I want to split my database and have the front end Excel for mulitple users.
How do I make Excel the front end?
Click to expand...
Click to expand...
Click to expand...
 
I forgot to ask about the criteria would [forms]![form name]![field name]
cover say if I wanted to see all the data that was received from a start date
to an end date.

scubadiver said:
The one thing I forgot to ask is whether you have sorted out your unique
record identifiers.

With the date criteria what I normally do is create a form and insert an
unbound text box or combo box and reference the form name in the criteria row
of the date field in the query:

[forms]![form name]![field name]


Marc said:
It's working perfectly...Thanks. Now I have a ReceivedDate Field in my query.
I wanted a criteria to search by date, how would I write that in the query?

scubadiver said:
Ching, Ching!!! :-)

Are you sure there will be ten users only?

Create duplicate tables each with their own Excel link and use a union query
to create a master query.

SELECT [FIELD1], [FIELD2]
From Table1

UNION SELECT [FIELD1], [FIELD2]
From Table2

etc ....

UNION SELECT [FIELD1], [FIELD2]
From Table10;


The problem with Excel is how users will be entering information. Simply
entering into rows or through a form? You are better off asking in the Excel
forum for that one.


--
"Loose Change 2nd Edition" has been seen by almost 7 million people on
Google video


:

There will be 10 users. A union query huh? What is the proccess to make a
union query? I will look at the help munu too.

:


The only way to do it is to have multiple tables each with their own
spreadsheet and then use a UNION query to join them.

How many users though?

--
"Loose Change 2nd Edition" has been seen by almost 7 million people on
Google video


:

Thanks, I've tried everything to link multiple spreadsheets to one table in
Access. I give up. I'm telling my management it can't be done and just the
thought of having Excel as a front end kills me. I had to try because I was
told too. Gotta love the Corporate Life. Thanks again.

:


I have just seen your previous post. Customers eh? who needs them! :-)

The problem with that kind of attitude is that he/she is not developing
his/her staff in terms of career development and learning. rant over.

You *can* link an excel spreadsheet to a table using the "import" function.
On a network I believe you can make a spreadsheet a shared file. This means
multiple users can open the same spreadsheet but what it would mean for data
entry I wouldn't know.

It is worth a try.



--
"Loose Change 2nd Edition" has been seen by almost 7 million people on
Google video


:

I want to split my database and have the front end Excel for mulitple users.
How do I make Excel the front end?
Click to expand...
Click to expand...
Click to expand...
 
Nice! I don't know why I never thought of that. I will do that.

scubadiver said:
It would better to keep them in. Since each site is separate can't you have
a site prefix for each spreadsheet? A primary key doesn't have to be a number.



Marc said:
At first I had a unique identifier then I took it out, because I would have
10 diferrent spreadsheet that would have all the same unique identifier. I'm
sure there is a way to get the spreadsheet to have all different unique
identifiers but not sure how to do that. Or is there a way for Access to do
that? It's propably not a good idea to take out the unique identifiers, is it?

Thanks for your help again.

scubadiver said:
The one thing I forgot to ask is whether you have sorted out your unique
record identifiers.

With the date criteria what I normally do is create a form and insert an
unbound text box or combo box and reference the form name in the criteria row
of the date field in the query:

[forms]![form name]![field name]


:

It's working perfectly...Thanks. Now I have a ReceivedDate Field in my query.
I wanted a criteria to search by date, how would I write that in the query?

:


Ching, Ching!!! :-)

Are you sure there will be ten users only?

Create duplicate tables each with their own Excel link and use a union query
to create a master query.

SELECT [FIELD1], [FIELD2]
From Table1

UNION SELECT [FIELD1], [FIELD2]
From Table2

etc ....

UNION SELECT [FIELD1], [FIELD2]
From Table10;


The problem with Excel is how users will be entering information. Simply
entering into rows or through a form? You are better off asking in the Excel
forum for that one.


--
"Loose Change 2nd Edition" has been seen by almost 7 million people on
Google video


:

There will be 10 users. A union query huh? What is the proccess to make a
union query? I will look at the help munu too.

:


The only way to do it is to have multiple tables each with their own
spreadsheet and then use a UNION query to join them.

How many users though?

--
"Loose Change 2nd Edition" has been seen by almost 7 million people on
Google video


:

Thanks, I've tried everything to link multiple spreadsheets to one table in
Access. I give up. I'm telling my management it can't be done and just the
thought of having Excel as a front end kills me. I had to try because I was
told too. Gotta love the Corporate Life. Thanks again.

:


I have just seen your previous post. Customers eh? who needs them! :-)

The problem with that kind of attitude is that he/she is not developing
his/her staff in terms of career development and learning. rant over.

You *can* link an excel spreadsheet to a table using the "import" function.
On a network I believe you can make a spreadsheet a shared file. This means
multiple users can open the same spreadsheet but what it would mean for data
entry I wouldn't know.

It is worth a try.



--
"Loose Change 2nd Edition" has been seen by almost 7 million people on
Google video


:

I want to split my database and have the front end Excel for mulitple users.
How do I make Excel the front end?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top