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

lokanathas

Registered User.
Local time
Tomorrow, 04:12
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
 

vedika

Registered User.
Local time
Tomorrow, 04:12
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