I want to create a database which reads in fields from differently formatted files, what's the best way to go about this?

smmkaythebear · 16 days

Not really. Also, this is the first time I'm programming in ADO/DAO. So I'm a bit clueless with all these things.

More specifically, I'm hoping to learn more about:

Spec Files and auto-imports (I've been reading forums and sites but I haven't found a good source yet. Any suggestions?)
populating a field in vba to with user-specified content (I've been looking at

Dim db As DAO.Database Dim tdf As DAO.TableDef Dim fld As DAO.Field

tdf.Append tdf.CreateField("NewField") Set fld as

Set db = CurrentDb()
Set tdf = db.CreateTableDef("NewTable")
Set fld = .CreateField("NewField", dbText)
fld.DefaultValue = "user-specified content"
fld.Fields.Append fld

But this hasn't been beneficial...

Any advice?

Thanks

smmkaythebear · 17 days

That's exactly what I want. I don't know how to execute

You can set up the data mapping using File>GetExternalData>Import, then Advanced... and build an import spec which you can use later in your VBA code

though

smmkaythebear · 17 days

Sorry, concise and direct explanations are not my forte.

I have 3 separate files I want to import into a common database but the field names in the sources are different. I will be sweeping a folder for the files, so tapping into the source of these files is not critical.

The 3 files all have personal information related to an item a user has, namely title, length of possession, location where the item was purchased, title of the item, color, size, and etc. The reason why there are 3 separate formats of the same information is because they're from 3 distinct systems, each with their own unique field naming conventions.

What I want to do is:

Autoimport files at the start of this database by sweeping a folder as text files
Create a form that I can open at the start of each workflow that lists all the imported tables within a combobox
When I select a table within the combobox, vba code will read-in the table's field names
Then, if I click a command button, the selected table's fields will be renamed with output file's "standard" field names and saved as output files.

Essentially, I want the code to read in a table's fields, take fields from that table that are also in the output table, save it in output table format, and export out the output table. One another thing is that the output table always has a static count of 9 fields. So, if there are fields in the output table that don't match to the imported table's fields thoase fields should be populated with null values. I would typically do this with a predefined table and append queries, but I think it would take too long and I don't know how to account for different field names

The_Abdicator · 17 days

wait, i thought recent studies have shown that brain functions aren't as highly localized as Mr.Gage's case.

AceOfJesters · 27 days

Try these. I wear this to work every day and I haven't been disciplined... yet: http://www.vivobarefoot.com/us/kids/ra-kids-14.html

smmkaythebear · 28 days

It comes from a vendor which uses its own secret database

smmkaythebear · 28 days

oh... I had no idea. thanks! does this mean i necessarily need to have the database set up before running the query or is it possible for this query to create the table and the database it will householded under?

smmkaythebear · 28 days

random copies of the subsets. Typically, I do this by

Select TOP Control_Count * FROM Subset1 where certain criteria Order by Rnd([Field]);

smmkaythebear · 28 days

I also want to hold out control groups from each of the 25 subsets. How do I do something like this? Do I need to use one of tabledefs? I've had 0 formal training in Access and have not found good source which explains DAO's in detail...

smmkaythebear · 28 days

I think that's the ideal solution in the end but due to my current team's skill set, myself included, Access is the only viable option

smmkaythebear · 28 days

It will be massive. I would estimate to be roughly 1million rows which I will use with a separate server

smmkaythebear · 28 days

What I need to do is create a control group and a target from from each of the 25 subsets. Then, to archive them, export them out to a single folder, where I can aggregate with other lists.

I also want to hold out an x % of each 25 subset and I'm thinking in order to achieve this, I need to write some code which involves TableDefs. However, I haven't found adequate resources to achieve this yet.

smmkaythebear · 28 days

I wasn't aware I could use a query make a table in a separate database from the one that is running the query. How do I do this?

smmkaythebear · 1 month

In the end, 25 datasets need to be queried differently, depending on each's selection criteria, then rolled up into a 2 tables and exported as text, xls, or csv files to a single location. Ideally, I would have error logs, timer, and record-keeping functions to track the progress of each.

The ultimate output can be produced sequentially and no single database needs to contain all the datasets in a single location. That is the reason why I prefer to have a Master database kick off 25 databases in succession, since, that way, I could minimize data corruption issues. However, I don't know the API's to acomplish this task or if it's even possible in Access.

Lastly, I would very much like to start with a single form in the Master database and use it to determine which of the 25 subsets to run at any given time. Then with a click of a button, I would kick off the process and review the error logs or output logs.

smmkaythebear · 1 month

could you please elaborate a little?

custerb11 · 3 months

too bad harbraugh wanted to make flacco a passer and didn't use rice and williams on the back. they would've torn shit up

tombaban · 4 months

they put more faith in their collective system than individuals. as a result they tend to side with numbers.

moosetracks24 · 4 months

i agree with everything you just said, but from my point of view, the skeleton seems more symbolic of death or the next state of our physical selves, a perspective/perception which we may never have. As if a man had died and the his soul was peering down at his remains, pondering.

The piece says to me: How would you look back on your life?; Or, Have you lived?

gmolinari · 4 months

This is how is how I first read Thus Spake Zarathustra- chapter by chapter with Jung's analysis. It was a mind blowing during my freshmen year in college

whatistug · 4 months

oh, and happy new year!

whatistug · 4 months

i'm at a loss for words; it's absolutely stunning. where did you learn this craft?

re1 · 5 months

Mind if I ask how many you've sunk into this single pic? I typically sacrifice 1 or 2 accidentally from dropping them

smmkaythebear

TROPHY CASE

you'll need to login or register to do that

create a new account

login