Please help with underlayvariables in Access

  • Thread starter Thread starter michellesihdu
  • Start date Start date
M

michellesihdu

Hi everybody
I’m trying to import Excel to Access.
How/where do I define variables my own variables? I've found many
examples where people uses variables in Access that they have defined
on there own.

Here is an example that is frequently used:
Dim rstImport As DAO.Recordset

When I tried to use the same line my own program an error says that
the variable is not defined.

Since I don’t know how and where to define those variables, as used in
previous line, I do need help.

Thanks in advance
/Michelle

(e-mail address removed)
 
Michelle

You are describing a "how" (import Excel using DAO).

"What" do you want to end up with? Do you need to import the data (i.e.,
make a copy in Access), or would it be sufficient to link to the data in
Excel?

More info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP

Hi everybody
I’m trying to import Excel to Access.
How/where do I define variables my own variables? I've found many
examples where people uses variables in Access that they have defined
on there own.

Here is an example that is frequently used:
Dim rstImport As DAO.Recordset

When I tried to use the same line my own program an error says that
the variable is not defined.

Since I don’t know how and where to define those variables, as used in
previous line, I do need help.

Thanks in advance
/Michelle

(e-mail address removed)
 
Hi
Thanks for answering, really appreciate it.

You are absolutely right, I am trying to import an Excelarc to Access,
with the following line since I’ve seen other used it:
Dim rstImport As DAO.Recordset.

But I get stuck when I compile Access.
The Excelark has 4 columns but the AccessDB has 9 columns so I need to
read every line in excel and also do some programming so that I can
fill all columns in Access correct.
Perhaps there’s some other way to read all lines in Excel and then do
some programming to fill the rest of the columns.

Thanks again for answering
/Michelle
 
Hi
Thanks for answering, really appreciate it.

You are absolutely right, I am trying to import an Excelarc to Access,
with the following line since I’ve seen other used it:
Dim rstImport As DAO.Recordset.

But I get stuck when I compile Access.
The Excelark has 4 columns but the AccessDB has 9 columns so I need to
read every line in excel and also do some programming so that I can
fill all columns in Access correct.
Perhaps there’s some other way to read all lines in Excel and then do
some programming to fill the rest of the columns.

Thanks again for answering
/Michelle
 
Michelle

You are describing a "how" (import Excel using DAO).

"What" do you want to end up with?  Do you need to import the data (i.e..,
make a copy in Access), or would it be sufficient to link to the data in
Excel?

More info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP


Hi everybody
I’m trying to import Excel to Access.
How/where do I define variables my own variables? I've found many
examples where people uses variables in Access that they have defined
on there own.

Here is an example that is frequently used:
Dim rstImport As DAO.Recordset

When I tried to use the same line my own program an error says that
the variable is not defined.

Since I don’t know how and where to define those variables, as used in
previous line, I do need help.

Thanks in advance
/Michelle

(e-mail address removed)
Click to expand...

Hi
Thanks for answering, really appreciate it.

You are absolutely right, I am trying to import an Excelarc to Access,
with the following line since I’ve seen other used it:
Dim rstImport As DAO.Recordset.

But I get stuck when I compile Access.
The Excelark has 4 columns but the AccessDB has 9 columns so I need to
read every line in excel and also do some programming so that I can
fill all columns in Access correct.
Perhaps there’s some other way to read all lines in Excel and then do
some programming to fill the rest of the columns.

Thanks again for answering
/Michelle
 
Hi
Thanks for answering, really appreciate it.

You are absolutely right, I am trying to import an Excelarc to Access,
with the following line since I’ve seen other used it:
Dim rstImport As DAO.Recordset.

But I get stuck when I compile Access.
The Excelark has 4 columns but the AccessDB has 9 columns so I need to
read every line in excel and also do some programming so that I can
fill all columns in Access correct.
Perhaps there’s some other way to read all lines in Excel and then do
some programming to fill the rest of the columns.

Thanks again for answering
/Michelle
 
Michelle

You are describing a "how" (import Excel using DAO).

"What" do you want to end up with?  Do you need to import the data (i.e..,
make a copy in Access), or would it be sufficient to link to the data in
Excel?

More info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP


Hi everybody
I’m trying to import Excel to Access.
How/where do I define variables my own variables? I've found many
examples where people uses variables in Access that they have defined
on there own.

Here is an example that is frequently used:
Dim rstImport As DAO.Recordset

When I tried to use the same line my own program an error says that
the variable is not defined.

Since I don’t know how and where to define those variables, as used in
previous line, I do need help.

Thanks in advance
/Michelle

(e-mail address removed)
Click to expand...

Hi
Thanks for answering, really appreciate it.

You are absolutely right, I am trying to import an Excelarc to Access,
with the following line since I’ve seen other used it:
Dim rstImport As DAO.Recordset.

But I get stuck when I compile Access.
The Excelark has 4 columns but the AccessDB has 9 columns so I need to
read every line in excel and also do some programming so that I can
fill all columns in Access correct.
Perhaps there’s some other way to read all lines in Excel and then do
some programming to fill the rest of the columns.

Thanks again for answering
/Michelle
 
Michelle

You are describing a "how" (import Excel using DAO).

"What" do you want to end up with?  Do you need to import the data (i.e..,
make a copy in Access), or would it be sufficient to link to the data in
Excel?

More info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP


Hi everybody
I’m trying to import Excel to Access.
How/where do I define variables my own variables? I've found many
examples where people uses variables in Access that they have defined
on there own.

Here is an example that is frequently used:
Dim rstImport As DAO.Recordset

When I tried to use the same line my own program an error says that
the variable is not defined.

Since I don’t know how and where to define those variables, as used in
previous line, I do need help.

Thanks in advance
/Michelle

(e-mail address removed)
Click to expand...

Hi
Thanks for answering, really appreciate it.

You are absolutely right, I am trying to import an Excelarc to Access,
with the following line since I’ve seen other used it:
Dim rstImport As DAO.Recordset.

But I get stuck when I compile Access.
The Excelark has 4 columns but the AccessDB has 9 columns so I need to
read every line in excel and also do some programming so that I can
fill all columns in Access correct.
Perhaps there’s some other way to read all lines in Excel and then do
some programming to fill the rest of the columns.

Thanks again for answering
/Michelle
 
Again, why import if you only need to read the Excel data?

Consider linking to it, then using queries to append from the Excel data
into your more permanent Access tables.

Regards

Jeff Boyce
Microsoft Office/Access MVP

Hi
Thanks for answering, really appreciate it.

You are absolutely right, I am trying to import an Excelarc to Access,
with the following line since I’ve seen other used it:
Dim rstImport As DAO.Recordset.

But I get stuck when I compile Access.
The Excelark has 4 columns but the AccessDB has 9 columns so I need to
read every line in excel and also do some programming so that I can
fill all columns in Access correct.
Perhaps there’s some other way to read all lines in Excel and then do
some programming to fill the rest of the columns.

Thanks again for answering
/Michelle
 
Hi
Thanks for answering, really appreciate it.

You are absolutely right, I am trying to import an Excelarc to Access,
with the following line since I’ve seen other used it:
Dim rstImport As DAO.Recordset.

But I get stuck when I compile Access.
The Excelark has 4 columns but the AccessDB has 9 columns so I need to
read every line in excel and also do some programming so that I can
fill all columns in Access correct.
Perhaps there’s some other way to read all lines in Excel and then do
some programming to fill the rest of the columns.

Thanks again for answering
/Michelle
 
Hi again
Thanks for answering, really appreciate it.

You are absolutely right, I am trying to import an arc in Excel to
Access, with the following line since I’ve seen other used it:
Dim rstImport As DAO.Recordset.

But I get stuck when I compile Access.
The arc in Excel has 4 columns but the AccessDB has 9 columns so I
need to read every line in excel and also do some programming so that
I can fill all columns in Access correct.
Perhaps there’s some other way to read all lines in Excel and then do
some programming to fill the rest of the columns.

Thanks again for answering
/Michelle

(e-mail address removed)
 
Hi again
Thanks for answering, really appreciate it.

You are absolutely right, I am trying to import an arc in Excel to
Access, with the following line since I’ve seen other used it:
Dim rstImport As DAO.Recordset.

But I get stuck when I compile Access.
The arc in Excel has 4 columns but the AccessDB has 9 columns so I
need to read every line in excel and also do some programming so that
I can fill all columns in Access correct.
Perhaps there’s some other way to read all lines in Excel and then do
some programming to fill the rest of the columns.

Thanks again for answering
/Michelle

(e-mail address removed)
 
Hi again
Thanks for answering, really appreciate it.

You are absolutely right, I am trying to import an arc in Excel to
Access, with the following line since I’ve seen other used it:
Dim rstImport As DAO.Recordset.

But I get stuck when I compile Access.
The arc in Excel has 4 columns but the AccessDB has 9 columns so I
need to read every line in excel and also do some programming so that
I can fill all columns in Access correct.
Perhaps there’s some other way to read all lines in Excel and then do
some programming to fill the rest of the columns.

Thanks again for answering
/Michelle

(e-mail address removed)













- Visa citerad text -
Click to expand...

Hi Jeff
As you ask “why import if you only need to read the Excel data”?
You are absolutely right I’m satisfied with reading only, how do I do
that?
Second issue I also need to be able to do some programming since I
only have 4 columns in Excel but 9 in Access.

Thanks for taking some time to help me
/Michelle
 
General questions (and descriptions) usually get general responses.

If you want to "link" to Excel (or other data sources), take a look at
"external data" in Access HELP. "How" will depend on which version of
Access you are using.

I have no idea what your "4 columns" and "9 columns" represent, so I don't
have enough background to tell you "how".

If you are asking how to get data from Excel to Access, take a look at
append queries (and update queries).

Regards

Jeff Boyce
Microsoft Office/Access MVP


Hi again
Thanks for answering, really appreciate it.

You are absolutely right, I am trying to import an arc in Excel to
Access, with the following line since I’ve seen other used it:
Dim rstImport As DAO.Recordset.

But I get stuck when I compile Access.
The arc in Excel has 4 columns but the AccessDB has 9 columns so I
need to read every line in excel and also do some programming so that
I can fill all columns in Access correct.
Perhaps there’s some other way to read all lines in Excel and then do
some programming to fill the rest of the columns.

Thanks again for answering
/Michelle

(e-mail address removed)













- Visa citerad text -
Click to expand...

Hi Jeff
As you ask “why import if you only need to read the Excel data”?
You are absolutely right I’m satisfied with reading only, how do I do
that?
Second issue I also need to be able to do some programming since I
only have 4 columns in Excel but 9 in Access.

Thanks for taking some time to help me
/Michelle
 
Back
Top