Please help with underlayvariables in Access

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)
 
J

Jeff Boyce

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)
 
M

michellesihdu

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
 
M

michellesihdu

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
 
M

michellesihdu

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
 
M

michellesihdu

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
 
M

michellesihdu

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
 
M

michellesihdu

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
 
J

Jeff Boyce

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
 
M

michellesihdu

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
 
M

michellesihdu

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)
 
M

michellesihdu

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)
 
M

michellesihdu

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
 
J

Jeff Boyce

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Import Excel to Access, define variable 1
VBA word change keys 0
Drop down list control value in vba 2
Help with MID function 4
Help creating a search form in Access XP 0
Converting excel to PDF, single page converts to multiple HELP! 1
Visual Basic DLookup returns null 3
importing excel worksheet to Access table 2

Top