Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't import data to access | Excel Discussion (Misc queries) | |||
How do I import from Access to Excel | Excel Discussion (Misc queries) | |||
Import from Access?? | Excel Discussion (Misc queries) | |||
Import Access into Excel | Excel Discussion (Misc queries) | |||
Need to import to Access | New Users to Excel |