.XLS Import Auto Date Assign

[NeonSky via AccessMonster.com]

Hello Everyone!

Part I: Ok here is what I am attempting to do. I have a .xls import file and
I am creating a table. What I would like to have happen is to assign a
date/time stamp to each record in the table.

Part II: Ok the entire process is triggered by a macro, when the macro ends I
would like the contents of the import table above to be sent to a history
table, and the contents of the import table above to clear post macro
resolution.

Happy to provide any additional info!

Thanks!

 

[strive4peace]

Hi Neon,

I can help you out with VBA code... but not using a macro... interested?

Also, please tell me just a bit more about your process...

do you import the XLS file manually or using code? Are you using a
macro to do it?

what are you doing with the data when it is imported? Transferring it
to other tables?

Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*

 

[NeonSky via AccessMonster.com]

Hello Crystal,

I have yet to decide what will work best, a manual/or macro based import. The
file that is going to be imported daily will have the same file name daily....
So I leaning towards a manual import where the user manually attaches the
present date to the end of the file to differentiate one file from the next.

Once the data is imported to a single table a series of querries are applied
to disseminate the data into multiple tables.

Hope this helps and am happy to elaborate!

Thanks!!

Hi Neon,

I can help you out with VBA code... but not using a macro... interested?

Also, please tell me just a bit more about your process...

do you import the XLS file manually or using code? Are you using a
macro to do it?

what are you doing with the data when it is imported? Transferring it
to other tables?

Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*

Hello Everyone!

[quoted text clipped - 10 lines]

Thanks!

 

[strive4peace]

Hi Neon,

you didn't say anything about VBA code...yes? no?

VBA is not the same as a macro... if you don't know the difference or
need some fundamentals, email me and put "VBA Manual" in the subject
line -- I will send you the first 3 chapters of a VBA manual I am writing

if you want to code it, you can

1. make a form with a browse button for a filename
(or the process can look for a certain filename with today's date embedded)
2. have an IMPORT command button that gets the specified file and saves
it either in a table that gets overwritten (like "ImportData") or an
import table with its own name
3. then, depending on how you are going to transfer the data, I find it
handy to add some ID fields to the ImportData table to match up records
first -- then I can see what needs to be added or updated. This has to
be done with code but is not necessary if you already have all the
queries to move it (just extra tracking information on what happened to
the imported data)

From your last post, I am assuming that you are currently using a macro
to run a series of action queries? If you code the other parts, are you
interested in converting the macro to code too? (really, it isn't so
hard to do)

Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*

Hello Crystal,

I have yet to decide what will work best, a manual/or macro based import. The
file that is going to be imported daily will have the same file name daily....
So I leaning towards a manual import where the user manually attaches the
present date to the end of the file to differentiate one file from the next.

Once the data is imported to a single table a series of querries are applied
to disseminate the data into multiple tables.

Hope this helps and am happy to elaborate!

Thanks!!

Hi Neon,

I can help you out with VBA code... but not using a macro... interested?

Also, please tell me just a bit more about your process...

do you import the XLS file manually or using code? Are you using a
macro to do it?

what are you doing with the data when it is imported? Transferring it
to other tables?

Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*

Hello Everyone!

[quoted text clipped - 10 lines]

Thanks!