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...
 

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

Access Importing csv daily files into access 2007 1
Excel to Access - User needs Access installed? 1
How to export table from outlook into ms access table? 0
Simple VBA Macro to import Data 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Access Import & Link section grayed out MS Access 2010 1
Best way to get data from Access 2003 to Excel 2003 6
Importing Data from Access Query to Excel Sheet 4

Back
Top