IP Address

  • Thread starter Thread starter Arnie
  • Start date Start date
A

Arnie

Hi folks i am trying to use transferspreadsheet and in some of the cells are
IP address but when i attempt this i get an error message saying a problem
has occured and that either it is due to data type or validation rules.
MyTable is set to text and there are no validation rules applied.

ta in advance
 
Hi Arnie

I have just tried to reproduce your problem and IP addresses import
perfectly as text. Can you please give us some more information:
What versions of Access and Excel?
What else is in the spreadsheet?
Specifically, is there numeric data in the first few rows of the IP
address column?
Are you using acImport or acLink?
 
Graham hi thanks for replying.

Excel 2003 SP3
Access 2003 SP3

acimport

the ip Address is just held in various cells which are formated as general
in excel
it is not an ip specific coloumn

code is

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "tblTemp",
strFile, No, "Settings!D3:D5"
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "tblTemp",
strFile, No, "Settings!D7:D8"
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "tblTemp",
strFile, No, "Settings!D10:D11"
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "tblTemp",
strFile, No, "Settings!D13:D21"
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "tblTemp",
strFile, No, "Settings!D23:D28"
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "tblTemp",
strFile, No, "Settings!D30:D30"
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "tblTemp",
strFile, No, "Settings!D32:D34"
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "tblTemp",
strFile, No, "Settings!D36:D38"
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "tblTemp",
strFile, No, "Settings!C1:C1"

Graham Mandeno said:
Hi Arnie

I have just tried to reproduce your problem and IP addresses import
perfectly as text. Can you please give us some more information:
What versions of Access and Excel?
What else is in the spreadsheet?
Specifically, is there numeric data in the first few rows of the IP
address column?
Are you using acImport or acLink?

--
Thanks :-)

Graham Mandeno [Access MVP]
Auckland, New Zealand

Arnie said:
Hi folks i am trying to use transferspreadsheet and in some of the cells
are
IP address but when i attempt this i get an error message saying a problem
has occured and that either it is due to data type or validation rules.
MyTable is set to text and there are no validation rules applied.

ta in advance
Click to expand...
Click to expand...
 
Graham hope you read this thanks for your help
but i seem to have waisted your time for which i appologise. My brain wasn't
in gear
i was using a temp table to pass the dat through and that was set to Data
type Number. Changed it to text and works fine. sorry again for waisting time

Arnie

Graham Mandeno said:
Hi Arnie

I have just tried to reproduce your problem and IP addresses import
perfectly as text. Can you please give us some more information:
What versions of Access and Excel?
What else is in the spreadsheet?
Specifically, is there numeric data in the first few rows of the IP
address column?
Are you using acImport or acLink?

--
Thanks :-)

Graham Mandeno [Access MVP]
Auckland, New Zealand

Arnie said:
Hi folks i am trying to use transferspreadsheet and in some of the cells
are
IP address but when i attempt this i get an error message saying a problem
has occured and that either it is due to data type or validation rules.
MyTable is set to text and there are no validation rules applied.

ta in advance
Click to expand...
Click to expand...
 
Thanks Arnie. Sometimes we forget to look for the easiest explanation.
Glad you got it solved!

--
Good Luck :-)

Graham Mandeno [Access MVP]
Auckland, New Zealand

Arnie said:
Graham hope you read this thanks for your help
but i seem to have waisted your time for which i appologise. My brain
wasn't
in gear
i was using a temp table to pass the dat through and that was set to Data
type Number. Changed it to text and works fine. sorry again for waisting
time

Arnie

Graham Mandeno said:
Hi Arnie

I have just tried to reproduce your problem and IP addresses import
perfectly as text. Can you please give us some more information:
What versions of Access and Excel?
What else is in the spreadsheet?
Specifically, is there numeric data in the first few rows of the IP
address column?
Are you using acImport or acLink?

--
Thanks :-)

Graham Mandeno [Access MVP]
Auckland, New Zealand

Arnie said:
Hi folks i am trying to use transferspreadsheet and in some of the
cells
are
IP address but when i attempt this i get an error message saying a
problem
has occured and that either it is due to data type or validation rules.
MyTable is set to text and there are no validation rules applied.

ta in advance
Click to expand...
Click to expand...
Click to expand...
 
Back
Top