Import to Access
 

We've created an Access Database. We have a bunch of data
in excel that needs to be transfered to access every day.
We've written a macro to organize our excel data into the
database format (a csv file). I would like to find out
what I need to write into my macro that would
automatically import the data into access for me. If
anybody has any help it would greatly be appreciated.
Thanks Eric

Import to Access
 

Why not create linked tables in Access that contain your spreadsheet info,
then all your data-importing is handled through SQL.

--
Michael Hopwood (Phobos)


"Eric" wrote in message
...
We've created an Access Database. We have a bunch of data
in excel that needs to be transfered to access every day.
We've written a macro to organize our excel data into the
database format (a csv file). I would like to find out
what I need to write into my macro that would
automatically import the data into access for me. If
anybody has any help it would greatly be appreciated.
Thanks Eric

Import to Access
 

....or run a query in MS Access to create a new Table e.g.

SELECT *
INTO MyNewTable
FROM [MyWorkSheet$] IN 'C:\MyWorkBook.xls' 'EXCEL 8.0;'


"Michael Hopwood" wrote in message ...
Why not create linked tables in Access that contain your spreadsheet info,
then all your data-importing is handled through SQL.

--
Michael Hopwood (Phobos)


"Eric" wrote in message
...
We've created an Access Database. We have a bunch of data
in excel that needs to be transfered to access every day.
We've written a macro to organize our excel data into the
database format (a csv file). I would like to find out
what I need to write into my macro that would
automatically import the data into access for me. If
anybody has any help it would greatly be appreciated.
Thanks Eric

Import to Access
 

It would be more efficient and require less effort to use linked tables.

--
Michael Hopwood (Phobos)


"onedaywhen" wrote in message
om...
...or run a query in MS Access to create a new Table e.g.

SELECT *
INTO MyNewTable
FROM [MyWorkSheet$] IN 'C:\MyWorkBook.xls' 'EXCEL 8.0;'


"Michael Hopwood" wrote in message
...
Why not create linked tables in Access that contain your spreadsheet
info,
then all your data-importing is handled through SQL.

--
Michael Hopwood (Phobos)


"Eric" wrote in message
...
We've created an Access Database. We have a bunch of data
in excel that needs to be transfered to access every day.
We've written a macro to organize our excel data into the
database format (a csv file). I would like to find out
what I need to write into my macro that would
automatically import the data into access for me. If
anybody has any help it would greatly be appreciated.
Thanks Eric

Import to Access
 

I don't despute that. However, "linked table" (two way traffic) is not
an import. I was just posting an alternative approach.

"Michael Hopwood" wrote in message ...
It would be more efficient and require less effort to use linked tables.

--
Michael Hopwood (Phobos)


"onedaywhen" wrote in message
om...
...or run a query in MS Access to create a new Table e.g.

SELECT *
INTO MyNewTable
FROM [MyWorkSheet$] IN 'C:\MyWorkBook.xls' 'EXCEL 8.0;'


"Michael Hopwood" wrote in message
...
Why not create linked tables in Access that contain your spreadsheet
info,
then all your data-importing is handled through SQL.

--
Michael Hopwood (Phobos)


"Eric" wrote in message
...
We've created an Access Database. We have a bunch of data
in excel that needs to be transfered to access every day.
We've written a macro to organize our excel data into the
database format (a csv file). I would like to find out
what I need to write into my macro that would
automatically import the data into access for me. If
anybody has any help it would greatly be appreciated.
Thanks Eric