Import to Access

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
 
M

Michael Hopwood

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

onedaywhen

....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;'
 
M

Michael Hopwood

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

onedaywhen

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

ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
Excel to Word to PDF workflow 1
Excel VBA macro to auto import new CSV file from fixed directory 1
Excel data vs Access database 3
Table Security in Access 2013 1
Client Access File Transfer from Excel 2010 3
Cannot import CSV file into ACCESS 1
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1

Top