Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
import excel file to access but only new data
I have a test log file that is generated daily in excel. I need to take that
to excel and import it into access. I can do this fine but i have to import all of it and it is about a 4meg file. i would like to look at the access table and only save the data is new for importing. can anyone give me some idea on how to do this? The tables contain dates, serial numbers, etc. right now i am sorting the excel file by the date column and deleting everything before 8-1-07. this at least makes a smaller file and a faster import. is there another way to do this or will checking access for data, and going back to excel take the same amount of time? The goal is to import as fast as possible with a reasonalbly small file size. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
import excel file to access but only new data
I think yuor process is good, you just need some automation of the process by
using a macro. I think you will need a input box asking when the last data of the import occured so you can filter the old data. You have a number of ways of filtering the data by date. I assume the input file is a text file which could be CSV or some other sttatndard formated text file 1) Write a macro the opens the text file and reads into excel only the data after a certain date 2) wirte a macro the inports the entire text file, sorts the file, and deletes the row before the selected date. If you post the text file data (I would only need a small number of rows) I can write the macro to filter the data. "Daniel M" wrote: I have a test log file that is generated daily in excel. I need to take that to excel and import it into access. I can do this fine but i have to import all of it and it is about a 4meg file. i would like to look at the access table and only save the data is new for importing. can anyone give me some idea on how to do this? The tables contain dates, serial numbers, etc. right now i am sorting the excel file by the date column and deleting everything before 8-1-07. this at least makes a smaller file and a faster import. is there another way to do this or will checking access for data, and going back to excel take the same amount of time? The goal is to import as fast as possible with a reasonalbly small file size. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
import data from access to excel | Excel Worksheet Functions | |||
Import MS Access data into MS Excel using VBA... | Excel Programming | |||
Excel file will not import to Access, what may be the cause | Excel Discussion (Misc queries) | |||
How do you change format on Excel .CSV file to import to access | Excel Discussion (Misc queries) | |||
VB Code or Excel macro to run Query/Import on Access file | Excel Programming |