Can i import data from portal to Access2010 (1 Viewer)

lokanathas

Registered User.
Local time
Today, 07:36
Joined
Aug 11, 2017
Messages
23
Hi,

Kindly let me know is there any possibility where i can import from Portal( with URL) to Access 2010.
i don't have any idea is this possible through Macro or SQL
 

jdraw

Super Moderator
Staff member
Local time
Yesterday, 22:06
Joined
Jan 23, 2006
Messages
15,364
You might get some ideas from this youtube video.

Also, search this youtube wiseowl web scraping

good luck.
 

vedika

Registered User.
Local time
Today, 07:36
Joined
Jan 24, 2019
Messages
11
Exporting Data from Microsoft Access 2010

1. Launch Micorsoft Access and open Database*
2. Open ODBC Datasource, click on Advanced tab and*add* 'SuppressInfoForDataTypes=nvarchar'. This property will instruct*the ODBC driver that datatype for the nvarchar datatype should not returned for this specific connection.* Suppression only applies to returning data type information from the OBDC driver. The application is still free to use the datatype in column declarations and when retrieving result sets.
3.* create table accesstab*(col1 long integer, col2 text (255) in* Microsoft*Access and insert row.
4. *Highlight table accesstab right click* -. Export ->ODBC Database ->* Machine Data Source ->Sybase IQ Datasource -> OK
5. Verify export by login into* SAP IQ database**
 

Users who are viewing this thread

Top Bottom