Actuarial Outpost

Actuarial Outpost (http://www.actuarialoutpost.com/actuarial_discussion_forum/index.php)
-   Software & Technology (http://www.actuarialoutpost.com/actuarial_discussion_forum/forumdisplay.php?f=17)
-   -   ODBC through MS Access basic question (http://www.actuarialoutpost.com/actuarial_discussion_forum/showthread.php?t=344425)

Noonien Soong 10-21-2019 11:32 AM

ODBC through MS Access basic question
 
Unfortunately for now, circumstances dictate or me to access a ODBC dataset that i'll need to use Access rather than sql or a language i'm more familiar with.

Once you connect to odbc sources, I've seen the syntax for the tables you're accessing to be something like the below.

wordswords.table1
wordswords.table2
wordywords.table_1
wordywords.table_2

If the above was what i was looking at in MS access for tables to link to, would "wordswords" and "wordywords" be considered schemas?


Humanly,

Noonien Soong

Colonel Smoothie 10-21-2019 12:37 PM

Quote:

Originally Posted by Noonien Soong (Post 9734801)
Unfortunately for now, circumstances dictate or me to access a ODBC dataset that i'll need to use Access rather than sql or a language i'm more familiar with.

Once you connect to odbc sources, I've seen the syntax for the tables you're accessing to be something like the below.

wordswords.table1
wordswords.table2
wordywords.table_1
wordywords.table_2

If the above was what i was looking at in MS access for tables to link to, would "wordswords" and "wordywords" be considered schemas?


Humanly,

Noonien Soong

I thought in VBA you have to declare your variables before you use them. What type is wordsbywords?

ALivelySedative 10-21-2019 01:19 PM

I use odbc w/ access from time to time, but don't have the technical knowledge to answer your question. I don't really know the definition of 'schema' here. I've just always considered them like subfolder names or something.

Alpha12 11-05-2019 03:22 PM

I would just click "record macro" in excel, import the table manually, then parse the resulting macro as I saw fit. GL, sounds like fun!


All times are GMT -4. The time now is 03:03 AM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.

Page generated in 0.17810 seconds with 9 queries