Import to Access

  • Thread starter Thread starter Eric
  • Start date Start date
E

Eric

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
 
Why not create linked tables in Access that contain your spreadsheet info,
then all your data-importing is handled through SQL.
 
....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;'
 
It would be more efficient and require less effort to use linked tables.

--
Michael Hopwood (Phobos)


onedaywhen said:
...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" <[email protected]> wrote in message
Why not create linked tables in Access that contain your spreadsheet info,
then all your data-importing is handled through SQL.
Click to expand...
Click to expand...
 
I don't despute that. However, "linked table" (two way traffic) is not
an import. I was just posting an alternative approach.

Michael Hopwood said:
It would be more efficient and require less effort to use linked tables.

--
Michael Hopwood (Phobos)


onedaywhen said:
...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" <[email protected]> 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)


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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top