Working betwen excel and acces
 

What I want to do now is the following:

I have a sheet in excel that every time I run a macro, 8 rows are copied to
this sheet, I want to INSERT (not to copy) the 8 rows but insted of exces, in
an acces workbook, Is this possible????

Access doesn't have workbooks they have tables.
In Access, why don't you relate a table to a worksheet in your workbook.
Go to Access and select...
FILE / GET EXTERNAL DATA / LINK TABLES / .....
HTH,
Gary Brown


"filo666" wrote:

What I want to do now is the following:

I have a sheet in excel that every time I run a macro, 8 rows are copied to
this sheet, I want to INSERT (not to copy) the 8 rows but insted of exces, in
an acces workbook, Is this possible????

Let me explaind you what I want to do, I Work for a company that sales paper
bags, they sell aprx. 600 orders per day, each order is made at most of 8
products, (and at less 1), each time that a sales employee sales something
they use a huge excel program that automaticaly discount the bags saled from
the stock, Excel has passed his capacity limit and its becoming slow and with
a lot of errors, so what I want to do is use excel to the math questions and
use acces for the data base questions, Could you help me whit this?

pd. Linking both databeses just make that I can have acces for my excel data
base in acces but the information is also saved inside excel so my problem
is´'t solved with a link.

"Gary Brown" wrote:

Access doesn't have workbooks they have tables.
In Access, why don't you relate a table to a worksheet in your workbook.
Go to Access and select...
FILE / GET EXTERNAL DATA / LINK TABLES / .....
HTH,
Gary Brown


"filo666" wrote:

What I want to do now is the following:

I have a sheet in excel that every time I run a macro, 8 rows are copied to
this sheet, I want to INSERT (not to copy) the 8 rows but insted of exces, in
an acces workbook, Is this possible????

Once you reach Excel's capacity of 65,536 rows per worksheet you and
your company should consider switching your entire procedure to Access
or some other database program. Quattro Pro lets you have up to
1,000,000 rows but I expect it will be slow as molasses for what you
want to do.

Bill

"filo666" wrote in message
...
Let me explaind you what I want to do, I Work for a company that sales
paper
bags, they sell aprx. 600 orders per day, each order is made at most of
8
products, (and at less 1), each time that a sales employee sales
something
they use a huge excel program that automaticaly discount the bags saled
from
the stock, Excel has passed his capacity limit and its becoming slow and
with
a lot of errors, so what I want to do is use excel to the math questions
and
use acces for the data base questions, Could you help me whit this?

pd. Linking both databeses just make that I can have acces for my excel
data
base in acces but the information is also saved inside excel so my
problem
is´'t solved with a link.

"Gary Brown" wrote:

Access doesn't have workbooks they have tables.
In Access, why don't you relate a table to a worksheet in your
workbook.
Go to Access and select...
FILE / GET EXTERNAL DATA / LINK TABLES / .....
HTH,
Gary Brown


"filo666" wrote:

What I want to do now is the following:

I have a sheet in excel that every time I run a macro, 8 rows are
copied to
this sheet, I want to INSERT (not to copy) the 8 rows but insted of
exces, in
an acces workbook, Is this possible????

Hi-

FWIW, I agree with Bill that the nature of your usage suggests that the
whole operation be converted to a relational database, such as Access. It is
quite capable of providing the calculated results you need, as well as many
other advantages that may even render much of the recalculating unnecessary.
You will still be able to use Excel to analyze/calculate the same data for
the advantages it offers. |:)

"filo666" wrote:

Let me explaind you what I want to do, I Work for a company that sales paper
bags, they sell aprx. 600 orders per day, each order is made at most of 8
products, (and at less 1), each time that a sales employee sales something
they use a huge excel program that automaticaly discount the bags saled from
the stock, Excel has passed his capacity limit and its becoming slow and with
a lot of errors, so what I want to do is use excel to the math questions and
use acces for the data base questions, Could you help me whit this?

pd. Linking both databeses just make that I can have acces for my excel data
base in acces but the information is also saved inside excel so my problem
is´'t solved with a link.

"Gary Brown" wrote:

Access doesn't have workbooks they have tables.
In Access, why don't you relate a table to a worksheet in your workbook.
Go to Access and select...
FILE / GET EXTERNAL DATA / LINK TABLES / .....
HTH,
Gary Brown


"filo666" wrote:

What I want to do now is the following:

I have a sheet in excel that every time I run a macro, 8 rows are copied to
this sheet, I want to INSERT (not to copy) the 8 rows but insted of exces, in
an acces workbook, Is this possible????

The problem is that I need a fast solution, I cant start programing
everything because we don't have any other way to print an register owr
sales; I might do what you're suggesting to do but when I solve my problem,
so, do you know how to insert 8 rows in a acces table using visual basic (a
macro)????

"CyberTaz" wrote:

Hi-

FWIW, I agree with Bill that the nature of your usage suggests that the
whole operation be converted to a relational database, such as Access. It is
quite capable of providing the calculated results you need, as well as many
other advantages that may even render much of the recalculating unnecessary.
You will still be able to use Excel to analyze/calculate the same data for
the advantages it offers. |:)

"filo666" wrote:

Let me explaind you what I want to do, I Work for a company that sales paper
bags, they sell aprx. 600 orders per day, each order is made at most of 8
products, (and at less 1), each time that a sales employee sales something
they use a huge excel program that automaticaly discount the bags saled from
the stock, Excel has passed his capacity limit and its becoming slow and with
a lot of errors, so what I want to do is use excel to the math questions and
use acces for the data base questions, Could you help me whit this?

pd. Linking both databeses just make that I can have acces for my excel data
base in acces but the information is also saved inside excel so my problem
is´'t solved with a link.

"Gary Brown" wrote:

Access doesn't have workbooks they have tables.
In Access, why don't you relate a table to a worksheet in your workbook.
Go to Access and select...
FILE / GET EXTERNAL DATA / LINK TABLES / .....
HTH,
Gary Brown


"filo666" wrote:

What I want to do now is the following:

I have a sheet in excel that every time I run a macro, 8 rows are copied to
this sheet, I want to INSERT (not to copy) the 8 rows but insted of exces, in
an acces workbook, Is this possible????