Tech Support Guy System Info Utility version 1.0.0.4
OS Version: Microsoft Windows 10 Home, 64 bit
Processor: Intel(R) Core(TM) i3-3227U CPU @ 1.90GHz, Intel64 Family 6 Model 58 Stepping 9
Processor Count: 4
RAM: 3977 Mb
Graphics Card: Intel(R) HD Graphics 4000, -2043 Mb
Hard Drives: C: 454 GB (402 GB Free);
Motherboard: Dell Inc., 033MX4
Antivirus: Windows Defender, Enabled and Updated
> I added this: I am using Windows Office Pro 2016
Am I going to have to do this each time I post?
I download data from Brisnet daily which I have to edit in order to use it. Since I started this, I have been doing it manually which is too time consuming. I am here to see if it can be automated and,if so, how?
Here are 2 files on Notepad. "Unedited" is as it downloads and "HOU" is after editing. I do this to put it into ACCESS and query for results. Now, if someone shows me how I can download the data directly into ACCESS as a usable table, I will name my next child for him/her! Automating this process will save plenty of time, so let us not explore that right now.
Can you know switch to the Form and then click the Main Menu "View" Symbol to get it to look like your screenshots 2 & 3 .
Then click the Command Button.
Great, we can import stuff but we need somewhere to put it.
I created a table called "Horse Imports" with 2 fields called Import Number & Horse Name.
Do you want to do the same or do you already have a table that you use?
The attached Excel screenshot shows what the table and imported data look like
Currently, doing it the copy and paste way with the data in .txt form, I import just the 2 fields: PPP and HORSE. Since I delete each of these as soon as I use them, the PPP is the key field. Using these 2 field designations they match my Main Database and the query I use works well. I believe all that would change if I use different field names.
I attempted to create the table, but I can't get out of this to my database.
On the line that says Table1 Click the small cross on the right hand side to close the table.
You can then right click table1 and select "Design View" from the list.
OK, view 2 shows that you have entered data in to the fields rather than enter field names, I hate that default view of the table.
So put the table in design view (3) and change the field names
from field1 to PPP
and field2 to Horse
Am I going to get rid of the ID Automated) field?
Do I need to change the data type for PPP? This is a number, not text. I do want it to be indexed, but not the name.
No unfortunately not, but I still enjoyed it.
To move on we need for you to re-open the VBA Editor by your method.
You need to change this line
Dim strFile As String, strInput As String
to
Dim strFile As String, strInput As String, varSplit As Variant, intCount As Integer, rs As Object, i As Integer, n As Long
OK, can you place the cursor where it is in the image and then press Enter to create a new line and then type or paste in the new line
Set rs = CurrentDb.OpenRecordset("ENTRIES IMPORT")
A forum community dedicated to tech experts and enthusiasts. Come join the discussion about articles, computer security, Mac, Microsoft, Linux, hardware, networking, gaming, reviews, accessories, and more!