UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> I Need To Import These Files From These Folders Into This Access Database, Access 2016    
 
   
NewtoVBA
post Nov 28 2017, 07:46 AM
Post#1



Posts: 303
Joined: 2-May 06



I'm sorry, I'm running into a crunch. I was working with the VBA that I added to import the files but kept running into errors. I'll be back on this afternoon to discuss this in more detail

If you could take a look at the tables in the database that's what they should look like after imported.
The folder with the files in them is what they look like when I receive them. I added a couple extra formats is that helps.
I was working on the VBA that I borrowed from Ken's Examples and they look like I could use a number of them to complete the import. Then I'll start the process of exporting them into some type of template of VBA code that allows me to create a workbook with tabs that I can name.

Thank you for looking at this hopefully I'm on track and if not, please steer me in the right direction
Attached File(s)
Attached File  Money_Movements.zip ( 1.02MB )Number of downloads: 6
 
Go to the top of the page
 
ranman256
post Nov 29 2017, 11:53 AM
Post#2



Posts: 785
Joined: 25-April 14



are you importing ALL the FILES in all the folders?
do the excel sheets = the layout of the tables so you can just TRANSFERSPREADSHEET?
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    10th December 2017 - 09:25 PM