By Andrew Gould
Download files here https://www.wiseowl.co.uk/vbamacros/...
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can join this channel to get access to perks:
/ @wiseowltutorials
Or you can click this link https://www.wiseowl.co.uk/donate?t=1'>https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!
Connection string https://www.connectionstrings.com/tex...
Schema.ini documentation https://docs.microsoft.com/enus/sql/...
This video shows you how to use a schema.ini file to control the import of text files using Active Data Objects in Excel VBA. You'll learn how to use the schema file to change the delimiter from commas to tabs, how to specify column names and data types and how to control the detection of date formats.
Chapters
00:00 The Question
01:30 Connecting to a Folder
03:46 Selecting from a CSV File
05:04 Copying a Recordset to a Worksheet
07:12 Connecting to a Tab Delimited File
08:38 Changing the Delimiter with a Schema File
10:40 Controlling Multiple Files with One Schema File
12:53 Indicating the Presence of Column Headers
13:32 Creating Column Headers in the Schema File
15:15 Specifying a Default Date Format
Visit https://www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Power BI, DAX, VBA, Python, Visual C#, Microsoft SQL Server, SQL Server Reporting Services SSRS, SQL Server Integration Services SSIS, Microsoft Access and more!