| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
automatic import from excel
I need to import data into access from an excel spreadsheet daily. Currently
I'm deleting to contents of yesterdays table then importing manually to get my queries and reports to refresh with todays data. Being an access novice I'm having a bit of trouble getting this all automated....any help would be greatfully received -- Thanks in advance...Phil |
|
#2
|
|||
|
|||
|
To help in the automation, I would open Access and link access to the excel
spreadsheet. FileGet external datalink tables(find the excel spreadsheet file with the correct tab) and select link. This creates a table in access directly linked to your excel file. Now setup query on the table in access. You will only have to specify the date to update your query. "Phil H" wrote: I need to import data into access from an excel spreadsheet daily. Currently I'm deleting to contents of yesterdays table then importing manually to get my queries and reports to refresh with todays data. Being an access novice I'm having a bit of trouble getting this all automated....any help would be greatfully received -- Thanks in advance...Phil |
|
#3
|
|||
|
|||
|
Now an added complication...after creating the link access is now recognising
a text column in excel as a numeric field in access...help! -- Thanks in advance...Phil "patrick" wrote: To help in the automation, I would open Access and link access to the excel spreadsheet. FileGet external datalink tables(find the excel spreadsheet file with the correct tab) and select link. This creates a table in access directly linked to your excel file. Now setup query on the table in access. You will only have to specify the date to update your query. "Phil H" wrote: I need to import data into access from an excel spreadsheet daily. Currently I'm deleting to contents of yesterdays table then importing manually to get my queries and reports to refresh with todays data. Being an access novice I'm having a bit of trouble getting this all automated....any help would be greatfully received -- Thanks in advance...Phil |
|
#4
|
|||
|
|||
|
Make sure that the data in excel is textin excel highlight the column that
is appearing as numeric to accessgo to datatext to columsthird screen and select textfinish In accessselect linked tabletoolsdatabase utilitieslinked table managerselect table and update. Hope this remedies your problem Pat "Phil H" wrote: Now an added complication...after creating the link access is now recognising a text column in excel as a numeric field in access...help! -- Thanks in advance...Phil "patrick" wrote: To help in the automation, I would open Access and link access to the excel spreadsheet. FileGet external datalink tables(find the excel spreadsheet file with the correct tab) and select link. This creates a table in access directly linked to your excel file. Now setup query on the table in access. You will only have to specify the date to update your query. "Phil H" wrote: I need to import data into access from an excel spreadsheet daily. Currently I'm deleting to contents of yesterdays table then importing manually to get my queries and reports to refresh with todays data. Being an access novice I'm having a bit of trouble getting this all automated....any help would be greatfully received -- Thanks in advance...Phil |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| import Windows Performance Log to excel | Excel Discussion (Misc queries) | |||
| Automatic Data Import | Excel Discussion (Misc queries) | |||
| import excel information | Excel Discussion (Misc queries) | |||
| How do I import data from a SECURED website into Excel? | Excel Discussion (Misc queries) | |||
| Can I import a Word table to an Excel spreadsheet? | Excel Worksheet Functions | |||
Linear Mode
